/*
*
* MasterOrderGoodsExample.java
* @author 18304
* @date 2021-01-20 14:35:47
*/
package com.steel.yfmall.cloud.assistant.po.oms;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class MasterOrderGoodsExample {
    /**
     * master_order_goods
     */
    protected String orderByClause;

    /**
     * master_order_goods
     */
    protected boolean distinct;

    /**
     * master_order_goods
     */
    protected List<Criteria> oredCriteria;

    private Integer limit;

    private Integer offset;

    private String groupByClause;

    private String selectFields;

    /**
     * 构造查询条件:master_order_goods
     * @Title: MasterOrderGoodsExample
     * @Description: ( )
     * @return 返回类型 null
     * @date 2021-01-20 14:35:47
     */
    public MasterOrderGoodsExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * 设置排序字段:master_order_goods
     * @Title: setOrderByClause
     * @Description: ( 设置排序字段 )
     * @param 参数说明 类型:String	名称:orderByClause 排序字段
     * @return 返回类型 null
     * @date 2021-01-20 14:35:47
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     * 获取排序字段:master_order_goods
     * @Title: getOrderByClause
     * @Description: ( 获取排序字段 )
     * @return 返回类型 java.lang.String
     * @date 2021-01-20 14:35:47
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * 设置过滤重复数据:master_order_goods
     * @Title: setDistinct
     * @Description: ( 设置过滤重复数据 )
     * @param 参数说明 类型:boolean	名称:distinct 是否过滤重复数据
     * @return 返回类型 null
     * @date 2021-01-20 14:35:47
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     * 是否过滤重复数据:master_order_goods
     * @Title: isDistinct
     * @Description: ( 是否过滤重复数据 )
     * @return 返回类型 boolean
     * @date 2021-01-20 14:35:47
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     * 获取当前的查询条件实例:master_order_goods
     * @Title: getOredCriteria
     * @Description: ( 获取当前的查询条件实例 )
     * @return 返回类型 java.util.List<Criteria>
     * @date 2021-01-20 14:35:47
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     *:master_order_goods
     * @Title: or
     * @Description: ( )
     *
     * @param 参数说明 类型:Criteria	名称:criteria 过滤条件实例
     * @return 返回类型 null
     * @date 2021-01-20 14:35:47
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     *:master_order_goods
     * @Title: or
     * @Description: ( )
     *
     * @return 返回类型 Criteria
     * @date 2021-01-20 14:35:47
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     * 创建一个查询条件:master_order_goods
     * @Title: createCriteria
     * @Description: ( 创建一个查询条件 )
     * @return 返回类型 Criteria
     * @date 2021-01-20 14:35:47
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     * 内部构建查询条件对象:master_order_goods
     * @Title: createCriteriaInternal
     * @Description: ( 内部构建查询条件对象 )
     * @return 返回类型 Criteria
     * @date 2021-01-20 14:35:47
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * 清除查询条件:master_order_goods
     * @Title: clear
     * @Description: ( 清除查询条件 )
     * @return 返回类型 null
     * @date 2021-01-20 14:35:47
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void limit(Integer offset, Integer limit) {
        this.offset = offset;
        this.limit = limit;
    }

    public Integer getLimit() {
        return limit;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return offset;
    }

    public void setGroupByClause(String groupByClause) {
        this.groupByClause = groupByClause;
    }

    public String getGroupByClause() {
        return groupByClause;
    }

    public void setSelectFields(String selectFields) {
        this.selectFields = selectFields;
    }

    public String getSelectFields() {
        return selectFields;
    }

    /**
     * @title master_order_goods表的实体类
     * @description master_order_goods
     * @version 1.0
     * @author 18304
     * @date 2021-01-20 14:35:47
     */
    protected abstract static class GeneratedCriteria implements java.io.Serializable {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Long value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Long value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Long value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Long value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Long value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Long value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Long> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Long> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Long value1, Long value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Long value1, Long value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andDepotCodeIsNull() {
            addCriterion("depot_code is null");
            return (Criteria) this;
        }

        public Criteria andDepotCodeIsNotNull() {
            addCriterion("depot_code is not null");
            return (Criteria) this;
        }

        public Criteria andDepotCodeEqualTo(String value) {
            addCriterion("depot_code =", value, "depotCode");
            return (Criteria) this;
        }

        public Criteria andDepotCodeNotEqualTo(String value) {
            addCriterion("depot_code <>", value, "depotCode");
            return (Criteria) this;
        }

        public Criteria andDepotCodeGreaterThan(String value) {
            addCriterion("depot_code >", value, "depotCode");
            return (Criteria) this;
        }

        public Criteria andDepotCodeGreaterThanOrEqualTo(String value) {
            addCriterion("depot_code >=", value, "depotCode");
            return (Criteria) this;
        }

        public Criteria andDepotCodeLessThan(String value) {
            addCriterion("depot_code <", value, "depotCode");
            return (Criteria) this;
        }

        public Criteria andDepotCodeLessThanOrEqualTo(String value) {
            addCriterion("depot_code <=", value, "depotCode");
            return (Criteria) this;
        }

        public Criteria andDepotCodeLike(String value) {
            addCriterion("depot_code like", value, "depotCode");
            return (Criteria) this;
        }

        public Criteria andDepotCodeNotLike(String value) {
            addCriterion("depot_code not like", value, "depotCode");
            return (Criteria) this;
        }

        public Criteria andDepotCodeIn(List<String> values) {
            addCriterion("depot_code in", values, "depotCode");
            return (Criteria) this;
        }

        public Criteria andDepotCodeNotIn(List<String> values) {
            addCriterion("depot_code not in", values, "depotCode");
            return (Criteria) this;
        }

        public Criteria andDepotCodeBetween(String value1, String value2) {
            addCriterion("depot_code between", value1, value2, "depotCode");
            return (Criteria) this;
        }

        public Criteria andDepotCodeNotBetween(String value1, String value2) {
            addCriterion("depot_code not between", value1, value2, "depotCode");
            return (Criteria) this;
        }

        public Criteria andDepotNameIsNull() {
            addCriterion("depot_name is null");
            return (Criteria) this;
        }

        public Criteria andDepotNameIsNotNull() {
            addCriterion("depot_name is not null");
            return (Criteria) this;
        }

        public Criteria andDepotNameEqualTo(String value) {
            addCriterion("depot_name =", value, "depotName");
            return (Criteria) this;
        }

        public Criteria andDepotNameNotEqualTo(String value) {
            addCriterion("depot_name <>", value, "depotName");
            return (Criteria) this;
        }

        public Criteria andDepotNameGreaterThan(String value) {
            addCriterion("depot_name >", value, "depotName");
            return (Criteria) this;
        }

        public Criteria andDepotNameGreaterThanOrEqualTo(String value) {
            addCriterion("depot_name >=", value, "depotName");
            return (Criteria) this;
        }

        public Criteria andDepotNameLessThan(String value) {
            addCriterion("depot_name <", value, "depotName");
            return (Criteria) this;
        }

        public Criteria andDepotNameLessThanOrEqualTo(String value) {
            addCriterion("depot_name <=", value, "depotName");
            return (Criteria) this;
        }

        public Criteria andDepotNameLike(String value) {
            addCriterion("depot_name like", value, "depotName");
            return (Criteria) this;
        }

        public Criteria andDepotNameNotLike(String value) {
            addCriterion("depot_name not like", value, "depotName");
            return (Criteria) this;
        }

        public Criteria andDepotNameIn(List<String> values) {
            addCriterion("depot_name in", values, "depotName");
            return (Criteria) this;
        }

        public Criteria andDepotNameNotIn(List<String> values) {
            addCriterion("depot_name not in", values, "depotName");
            return (Criteria) this;
        }

        public Criteria andDepotNameBetween(String value1, String value2) {
            addCriterion("depot_name between", value1, value2, "depotName");
            return (Criteria) this;
        }

        public Criteria andDepotNameNotBetween(String value1, String value2) {
            addCriterion("depot_name not between", value1, value2, "depotName");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnIsNull() {
            addCriterion("master_order_sn is null");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnIsNotNull() {
            addCriterion("master_order_sn is not null");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnEqualTo(String value) {
            addCriterion("master_order_sn =", value, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnNotEqualTo(String value) {
            addCriterion("master_order_sn <>", value, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnGreaterThan(String value) {
            addCriterion("master_order_sn >", value, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnGreaterThanOrEqualTo(String value) {
            addCriterion("master_order_sn >=", value, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnLessThan(String value) {
            addCriterion("master_order_sn <", value, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnLessThanOrEqualTo(String value) {
            addCriterion("master_order_sn <=", value, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnLike(String value) {
            addCriterion("master_order_sn like", value, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnNotLike(String value) {
            addCriterion("master_order_sn not like", value, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnIn(List<String> values) {
            addCriterion("master_order_sn in", values, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnNotIn(List<String> values) {
            addCriterion("master_order_sn not in", values, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnBetween(String value1, String value2) {
            addCriterion("master_order_sn between", value1, value2, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnNotBetween(String value1, String value2) {
            addCriterion("master_order_sn not between", value1, value2, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andOrderSnIsNull() {
            addCriterion("order_sn is null");
            return (Criteria) this;
        }

        public Criteria andOrderSnIsNotNull() {
            addCriterion("order_sn is not null");
            return (Criteria) this;
        }

        public Criteria andOrderSnEqualTo(String value) {
            addCriterion("order_sn =", value, "orderSn");
            return (Criteria) this;
        }

        public Criteria andOrderSnNotEqualTo(String value) {
            addCriterion("order_sn <>", value, "orderSn");
            return (Criteria) this;
        }

        public Criteria andOrderSnGreaterThan(String value) {
            addCriterion("order_sn >", value, "orderSn");
            return (Criteria) this;
        }

        public Criteria andOrderSnGreaterThanOrEqualTo(String value) {
            addCriterion("order_sn >=", value, "orderSn");
            return (Criteria) this;
        }

        public Criteria andOrderSnLessThan(String value) {
            addCriterion("order_sn <", value, "orderSn");
            return (Criteria) this;
        }

        public Criteria andOrderSnLessThanOrEqualTo(String value) {
            addCriterion("order_sn <=", value, "orderSn");
            return (Criteria) this;
        }

        public Criteria andOrderSnLike(String value) {
            addCriterion("order_sn like", value, "orderSn");
            return (Criteria) this;
        }

        public Criteria andOrderSnNotLike(String value) {
            addCriterion("order_sn not like", value, "orderSn");
            return (Criteria) this;
        }

        public Criteria andOrderSnIn(List<String> values) {
            addCriterion("order_sn in", values, "orderSn");
            return (Criteria) this;
        }

        public Criteria andOrderSnNotIn(List<String> values) {
            addCriterion("order_sn not in", values, "orderSn");
            return (Criteria) this;
        }

        public Criteria andOrderSnBetween(String value1, String value2) {
            addCriterion("order_sn between", value1, value2, "orderSn");
            return (Criteria) this;
        }

        public Criteria andOrderSnNotBetween(String value1, String value2) {
            addCriterion("order_sn not between", value1, value2, "orderSn");
            return (Criteria) this;
        }

        public Criteria andGoodsSnIsNull() {
            addCriterion("goods_sn is null");
            return (Criteria) this;
        }

        public Criteria andGoodsSnIsNotNull() {
            addCriterion("goods_sn is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsSnEqualTo(String value) {
            addCriterion("goods_sn =", value, "goodsSn");
            return (Criteria) this;
        }

        public Criteria andGoodsSnNotEqualTo(String value) {
            addCriterion("goods_sn <>", value, "goodsSn");
            return (Criteria) this;
        }

        public Criteria andGoodsSnGreaterThan(String value) {
            addCriterion("goods_sn >", value, "goodsSn");
            return (Criteria) this;
        }

        public Criteria andGoodsSnGreaterThanOrEqualTo(String value) {
            addCriterion("goods_sn >=", value, "goodsSn");
            return (Criteria) this;
        }

        public Criteria andGoodsSnLessThan(String value) {
            addCriterion("goods_sn <", value, "goodsSn");
            return (Criteria) this;
        }

        public Criteria andGoodsSnLessThanOrEqualTo(String value) {
            addCriterion("goods_sn <=", value, "goodsSn");
            return (Criteria) this;
        }

        public Criteria andGoodsSnLike(String value) {
            addCriterion("goods_sn like", value, "goodsSn");
            return (Criteria) this;
        }

        public Criteria andGoodsSnNotLike(String value) {
            addCriterion("goods_sn not like", value, "goodsSn");
            return (Criteria) this;
        }

        public Criteria andGoodsSnIn(List<String> values) {
            addCriterion("goods_sn in", values, "goodsSn");
            return (Criteria) this;
        }

        public Criteria andGoodsSnNotIn(List<String> values) {
            addCriterion("goods_sn not in", values, "goodsSn");
            return (Criteria) this;
        }

        public Criteria andGoodsSnBetween(String value1, String value2) {
            addCriterion("goods_sn between", value1, value2, "goodsSn");
            return (Criteria) this;
        }

        public Criteria andGoodsSnNotBetween(String value1, String value2) {
            addCriterion("goods_sn not between", value1, value2, "goodsSn");
            return (Criteria) this;
        }

        public Criteria andGoodsNameIsNull() {
            addCriterion("goods_name is null");
            return (Criteria) this;
        }

        public Criteria andGoodsNameIsNotNull() {
            addCriterion("goods_name is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsNameEqualTo(String value) {
            addCriterion("goods_name =", value, "goodsName");
            return (Criteria) this;
        }

        public Criteria andGoodsNameNotEqualTo(String value) {
            addCriterion("goods_name <>", value, "goodsName");
            return (Criteria) this;
        }

        public Criteria andGoodsNameGreaterThan(String value) {
            addCriterion("goods_name >", value, "goodsName");
            return (Criteria) this;
        }

        public Criteria andGoodsNameGreaterThanOrEqualTo(String value) {
            addCriterion("goods_name >=", value, "goodsName");
            return (Criteria) this;
        }

        public Criteria andGoodsNameLessThan(String value) {
            addCriterion("goods_name <", value, "goodsName");
            return (Criteria) this;
        }

        public Criteria andGoodsNameLessThanOrEqualTo(String value) {
            addCriterion("goods_name <=", value, "goodsName");
            return (Criteria) this;
        }

        public Criteria andGoodsNameLike(String value) {
            addCriterion("goods_name like", value, "goodsName");
            return (Criteria) this;
        }

        public Criteria andGoodsNameNotLike(String value) {
            addCriterion("goods_name not like", value, "goodsName");
            return (Criteria) this;
        }

        public Criteria andGoodsNameIn(List<String> values) {
            addCriterion("goods_name in", values, "goodsName");
            return (Criteria) this;
        }

        public Criteria andGoodsNameNotIn(List<String> values) {
            addCriterion("goods_name not in", values, "goodsName");
            return (Criteria) this;
        }

        public Criteria andGoodsNameBetween(String value1, String value2) {
            addCriterion("goods_name between", value1, value2, "goodsName");
            return (Criteria) this;
        }

        public Criteria andGoodsNameNotBetween(String value1, String value2) {
            addCriterion("goods_name not between", value1, value2, "goodsName");
            return (Criteria) this;
        }

        public Criteria andCustomCodeIsNull() {
            addCriterion("custom_code is null");
            return (Criteria) this;
        }

        public Criteria andCustomCodeIsNotNull() {
            addCriterion("custom_code is not null");
            return (Criteria) this;
        }

        public Criteria andCustomCodeEqualTo(String value) {
            addCriterion("custom_code =", value, "customCode");
            return (Criteria) this;
        }

        public Criteria andCustomCodeNotEqualTo(String value) {
            addCriterion("custom_code <>", value, "customCode");
            return (Criteria) this;
        }

        public Criteria andCustomCodeGreaterThan(String value) {
            addCriterion("custom_code >", value, "customCode");
            return (Criteria) this;
        }

        public Criteria andCustomCodeGreaterThanOrEqualTo(String value) {
            addCriterion("custom_code >=", value, "customCode");
            return (Criteria) this;
        }

        public Criteria andCustomCodeLessThan(String value) {
            addCriterion("custom_code <", value, "customCode");
            return (Criteria) this;
        }

        public Criteria andCustomCodeLessThanOrEqualTo(String value) {
            addCriterion("custom_code <=", value, "customCode");
            return (Criteria) this;
        }

        public Criteria andCustomCodeLike(String value) {
            addCriterion("custom_code like", value, "customCode");
            return (Criteria) this;
        }

        public Criteria andCustomCodeNotLike(String value) {
            addCriterion("custom_code not like", value, "customCode");
            return (Criteria) this;
        }

        public Criteria andCustomCodeIn(List<String> values) {
            addCriterion("custom_code in", values, "customCode");
            return (Criteria) this;
        }

        public Criteria andCustomCodeNotIn(List<String> values) {
            addCriterion("custom_code not in", values, "customCode");
            return (Criteria) this;
        }

        public Criteria andCustomCodeBetween(String value1, String value2) {
            addCriterion("custom_code between", value1, value2, "customCode");
            return (Criteria) this;
        }

        public Criteria andCustomCodeNotBetween(String value1, String value2) {
            addCriterion("custom_code not between", value1, value2, "customCode");
            return (Criteria) this;
        }

        public Criteria andIntlCodeIsNull() {
            addCriterion("intl_code is null");
            return (Criteria) this;
        }

        public Criteria andIntlCodeIsNotNull() {
            addCriterion("intl_code is not null");
            return (Criteria) this;
        }

        public Criteria andIntlCodeEqualTo(String value) {
            addCriterion("intl_code =", value, "intlCode");
            return (Criteria) this;
        }

        public Criteria andIntlCodeNotEqualTo(String value) {
            addCriterion("intl_code <>", value, "intlCode");
            return (Criteria) this;
        }

        public Criteria andIntlCodeGreaterThan(String value) {
            addCriterion("intl_code >", value, "intlCode");
            return (Criteria) this;
        }

        public Criteria andIntlCodeGreaterThanOrEqualTo(String value) {
            addCriterion("intl_code >=", value, "intlCode");
            return (Criteria) this;
        }

        public Criteria andIntlCodeLessThan(String value) {
            addCriterion("intl_code <", value, "intlCode");
            return (Criteria) this;
        }

        public Criteria andIntlCodeLessThanOrEqualTo(String value) {
            addCriterion("intl_code <=", value, "intlCode");
            return (Criteria) this;
        }

        public Criteria andIntlCodeLike(String value) {
            addCriterion("intl_code like", value, "intlCode");
            return (Criteria) this;
        }

        public Criteria andIntlCodeNotLike(String value) {
            addCriterion("intl_code not like", value, "intlCode");
            return (Criteria) this;
        }

        public Criteria andIntlCodeIn(List<String> values) {
            addCriterion("intl_code in", values, "intlCode");
            return (Criteria) this;
        }

        public Criteria andIntlCodeNotIn(List<String> values) {
            addCriterion("intl_code not in", values, "intlCode");
            return (Criteria) this;
        }

        public Criteria andIntlCodeBetween(String value1, String value2) {
            addCriterion("intl_code between", value1, value2, "intlCode");
            return (Criteria) this;
        }

        public Criteria andIntlCodeNotBetween(String value1, String value2) {
            addCriterion("intl_code not between", value1, value2, "intlCode");
            return (Criteria) this;
        }

        public Criteria andExtensionCodeIsNull() {
            addCriterion("extension_code is null");
            return (Criteria) this;
        }

        public Criteria andExtensionCodeIsNotNull() {
            addCriterion("extension_code is not null");
            return (Criteria) this;
        }

        public Criteria andExtensionCodeEqualTo(String value) {
            addCriterion("extension_code =", value, "extensionCode");
            return (Criteria) this;
        }

        public Criteria andExtensionCodeNotEqualTo(String value) {
            addCriterion("extension_code <>", value, "extensionCode");
            return (Criteria) this;
        }

        public Criteria andExtensionCodeGreaterThan(String value) {
            addCriterion("extension_code >", value, "extensionCode");
            return (Criteria) this;
        }

        public Criteria andExtensionCodeGreaterThanOrEqualTo(String value) {
            addCriterion("extension_code >=", value, "extensionCode");
            return (Criteria) this;
        }

        public Criteria andExtensionCodeLessThan(String value) {
            addCriterion("extension_code <", value, "extensionCode");
            return (Criteria) this;
        }

        public Criteria andExtensionCodeLessThanOrEqualTo(String value) {
            addCriterion("extension_code <=", value, "extensionCode");
            return (Criteria) this;
        }

        public Criteria andExtensionCodeLike(String value) {
            addCriterion("extension_code like", value, "extensionCode");
            return (Criteria) this;
        }

        public Criteria andExtensionCodeNotLike(String value) {
            addCriterion("extension_code not like", value, "extensionCode");
            return (Criteria) this;
        }

        public Criteria andExtensionCodeIn(List<String> values) {
            addCriterion("extension_code in", values, "extensionCode");
            return (Criteria) this;
        }

        public Criteria andExtensionCodeNotIn(List<String> values) {
            addCriterion("extension_code not in", values, "extensionCode");
            return (Criteria) this;
        }

        public Criteria andExtensionCodeBetween(String value1, String value2) {
            addCriterion("extension_code between", value1, value2, "extensionCode");
            return (Criteria) this;
        }

        public Criteria andExtensionCodeNotBetween(String value1, String value2) {
            addCriterion("extension_code not between", value1, value2, "extensionCode");
            return (Criteria) this;
        }

        public Criteria andExtensionIdIsNull() {
            addCriterion("extension_id is null");
            return (Criteria) this;
        }

        public Criteria andExtensionIdIsNotNull() {
            addCriterion("extension_id is not null");
            return (Criteria) this;
        }

        public Criteria andExtensionIdEqualTo(String value) {
            addCriterion("extension_id =", value, "extensionId");
            return (Criteria) this;
        }

        public Criteria andExtensionIdNotEqualTo(String value) {
            addCriterion("extension_id <>", value, "extensionId");
            return (Criteria) this;
        }

        public Criteria andExtensionIdGreaterThan(String value) {
            addCriterion("extension_id >", value, "extensionId");
            return (Criteria) this;
        }

        public Criteria andExtensionIdGreaterThanOrEqualTo(String value) {
            addCriterion("extension_id >=", value, "extensionId");
            return (Criteria) this;
        }

        public Criteria andExtensionIdLessThan(String value) {
            addCriterion("extension_id <", value, "extensionId");
            return (Criteria) this;
        }

        public Criteria andExtensionIdLessThanOrEqualTo(String value) {
            addCriterion("extension_id <=", value, "extensionId");
            return (Criteria) this;
        }

        public Criteria andExtensionIdLike(String value) {
            addCriterion("extension_id like", value, "extensionId");
            return (Criteria) this;
        }

        public Criteria andExtensionIdNotLike(String value) {
            addCriterion("extension_id not like", value, "extensionId");
            return (Criteria) this;
        }

        public Criteria andExtensionIdIn(List<String> values) {
            addCriterion("extension_id in", values, "extensionId");
            return (Criteria) this;
        }

        public Criteria andExtensionIdNotIn(List<String> values) {
            addCriterion("extension_id not in", values, "extensionId");
            return (Criteria) this;
        }

        public Criteria andExtensionIdBetween(String value1, String value2) {
            addCriterion("extension_id between", value1, value2, "extensionId");
            return (Criteria) this;
        }

        public Criteria andExtensionIdNotBetween(String value1, String value2) {
            addCriterion("extension_id not between", value1, value2, "extensionId");
            return (Criteria) this;
        }

        public Criteria andGoodsQtyIsNull() {
            addCriterion("goods_qty is null");
            return (Criteria) this;
        }

        public Criteria andGoodsQtyIsNotNull() {
            addCriterion("goods_qty is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsQtyEqualTo(Integer value) {
            addCriterion("goods_qty =", value, "goodsQty");
            return (Criteria) this;
        }

        public Criteria andGoodsQtyNotEqualTo(Integer value) {
            addCriterion("goods_qty <>", value, "goodsQty");
            return (Criteria) this;
        }

        public Criteria andGoodsQtyGreaterThan(Integer value) {
            addCriterion("goods_qty >", value, "goodsQty");
            return (Criteria) this;
        }

        public Criteria andGoodsQtyGreaterThanOrEqualTo(Integer value) {
            addCriterion("goods_qty >=", value, "goodsQty");
            return (Criteria) this;
        }

        public Criteria andGoodsQtyLessThan(Integer value) {
            addCriterion("goods_qty <", value, "goodsQty");
            return (Criteria) this;
        }

        public Criteria andGoodsQtyLessThanOrEqualTo(Integer value) {
            addCriterion("goods_qty <=", value, "goodsQty");
            return (Criteria) this;
        }

        public Criteria andGoodsQtyIn(List<Integer> values) {
            addCriterion("goods_qty in", values, "goodsQty");
            return (Criteria) this;
        }

        public Criteria andGoodsQtyNotIn(List<Integer> values) {
            addCriterion("goods_qty not in", values, "goodsQty");
            return (Criteria) this;
        }

        public Criteria andGoodsQtyBetween(Integer value1, Integer value2) {
            addCriterion("goods_qty between", value1, value2, "goodsQty");
            return (Criteria) this;
        }

        public Criteria andGoodsQtyNotBetween(Integer value1, Integer value2) {
            addCriterion("goods_qty not between", value1, value2, "goodsQty");
            return (Criteria) this;
        }

        public Criteria andGoodsPriceIsNull() {
            addCriterion("goods_price is null");
            return (Criteria) this;
        }

        public Criteria andGoodsPriceIsNotNull() {
            addCriterion("goods_price is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsPriceEqualTo(BigDecimal value) {
            addCriterion("goods_price =", value, "goodsPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsPriceNotEqualTo(BigDecimal value) {
            addCriterion("goods_price <>", value, "goodsPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsPriceGreaterThan(BigDecimal value) {
            addCriterion("goods_price >", value, "goodsPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("goods_price >=", value, "goodsPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsPriceLessThan(BigDecimal value) {
            addCriterion("goods_price <", value, "goodsPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("goods_price <=", value, "goodsPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsPriceIn(List<BigDecimal> values) {
            addCriterion("goods_price in", values, "goodsPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsPriceNotIn(List<BigDecimal> values) {
            addCriterion("goods_price not in", values, "goodsPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("goods_price between", value1, value2, "goodsPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("goods_price not between", value1, value2, "goodsPrice");
            return (Criteria) this;
        }

        public Criteria andTransactionPriceIsNull() {
            addCriterion("transaction_price is null");
            return (Criteria) this;
        }

        public Criteria andTransactionPriceIsNotNull() {
            addCriterion("transaction_price is not null");
            return (Criteria) this;
        }

        public Criteria andTransactionPriceEqualTo(BigDecimal value) {
            addCriterion("transaction_price =", value, "transactionPrice");
            return (Criteria) this;
        }

        public Criteria andTransactionPriceNotEqualTo(BigDecimal value) {
            addCriterion("transaction_price <>", value, "transactionPrice");
            return (Criteria) this;
        }

        public Criteria andTransactionPriceGreaterThan(BigDecimal value) {
            addCriterion("transaction_price >", value, "transactionPrice");
            return (Criteria) this;
        }

        public Criteria andTransactionPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("transaction_price >=", value, "transactionPrice");
            return (Criteria) this;
        }

        public Criteria andTransactionPriceLessThan(BigDecimal value) {
            addCriterion("transaction_price <", value, "transactionPrice");
            return (Criteria) this;
        }

        public Criteria andTransactionPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("transaction_price <=", value, "transactionPrice");
            return (Criteria) this;
        }

        public Criteria andTransactionPriceIn(List<BigDecimal> values) {
            addCriterion("transaction_price in", values, "transactionPrice");
            return (Criteria) this;
        }

        public Criteria andTransactionPriceNotIn(List<BigDecimal> values) {
            addCriterion("transaction_price not in", values, "transactionPrice");
            return (Criteria) this;
        }

        public Criteria andTransactionPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("transaction_price between", value1, value2, "transactionPrice");
            return (Criteria) this;
        }

        public Criteria andTransactionPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("transaction_price not between", value1, value2, "transactionPrice");
            return (Criteria) this;
        }

        public Criteria andSettlementPriceIsNull() {
            addCriterion("settlement_price is null");
            return (Criteria) this;
        }

        public Criteria andSettlementPriceIsNotNull() {
            addCriterion("settlement_price is not null");
            return (Criteria) this;
        }

        public Criteria andSettlementPriceEqualTo(BigDecimal value) {
            addCriterion("settlement_price =", value, "settlementPrice");
            return (Criteria) this;
        }

        public Criteria andSettlementPriceNotEqualTo(BigDecimal value) {
            addCriterion("settlement_price <>", value, "settlementPrice");
            return (Criteria) this;
        }

        public Criteria andSettlementPriceGreaterThan(BigDecimal value) {
            addCriterion("settlement_price >", value, "settlementPrice");
            return (Criteria) this;
        }

        public Criteria andSettlementPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("settlement_price >=", value, "settlementPrice");
            return (Criteria) this;
        }

        public Criteria andSettlementPriceLessThan(BigDecimal value) {
            addCriterion("settlement_price <", value, "settlementPrice");
            return (Criteria) this;
        }

        public Criteria andSettlementPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("settlement_price <=", value, "settlementPrice");
            return (Criteria) this;
        }

        public Criteria andSettlementPriceIn(List<BigDecimal> values) {
            addCriterion("settlement_price in", values, "settlementPrice");
            return (Criteria) this;
        }

        public Criteria andSettlementPriceNotIn(List<BigDecimal> values) {
            addCriterion("settlement_price not in", values, "settlementPrice");
            return (Criteria) this;
        }

        public Criteria andSettlementPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("settlement_price between", value1, value2, "settlementPrice");
            return (Criteria) this;
        }

        public Criteria andSettlementPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("settlement_price not between", value1, value2, "settlementPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountIsNull() {
            addCriterion("discount is null");
            return (Criteria) this;
        }

        public Criteria andDiscountIsNotNull() {
            addCriterion("discount is not null");
            return (Criteria) this;
        }

        public Criteria andDiscountEqualTo(BigDecimal value) {
            addCriterion("discount =", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountNotEqualTo(BigDecimal value) {
            addCriterion("discount <>", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountGreaterThan(BigDecimal value) {
            addCriterion("discount >", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("discount >=", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountLessThan(BigDecimal value) {
            addCriterion("discount <", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("discount <=", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountIn(List<BigDecimal> values) {
            addCriterion("discount in", values, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountNotIn(List<BigDecimal> values) {
            addCriterion("discount not in", values, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discount between", value1, value2, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discount not between", value1, value2, "discount");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyIsNull() {
            addCriterion("integral_money is null");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyIsNotNull() {
            addCriterion("integral_money is not null");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyEqualTo(BigDecimal value) {
            addCriterion("integral_money =", value, "integralMoney");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyNotEqualTo(BigDecimal value) {
            addCriterion("integral_money <>", value, "integralMoney");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyGreaterThan(BigDecimal value) {
            addCriterion("integral_money >", value, "integralMoney");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("integral_money >=", value, "integralMoney");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyLessThan(BigDecimal value) {
            addCriterion("integral_money <", value, "integralMoney");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("integral_money <=", value, "integralMoney");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyIn(List<BigDecimal> values) {
            addCriterion("integral_money in", values, "integralMoney");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyNotIn(List<BigDecimal> values) {
            addCriterion("integral_money not in", values, "integralMoney");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("integral_money between", value1, value2, "integralMoney");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("integral_money not between", value1, value2, "integralMoney");
            return (Criteria) this;
        }

        public Criteria andIntegralIsNull() {
            addCriterion("integral is null");
            return (Criteria) this;
        }

        public Criteria andIntegralIsNotNull() {
            addCriterion("integral is not null");
            return (Criteria) this;
        }

        public Criteria andIntegralEqualTo(BigDecimal value) {
            addCriterion("integral =", value, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralNotEqualTo(BigDecimal value) {
            addCriterion("integral <>", value, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralGreaterThan(BigDecimal value) {
            addCriterion("integral >", value, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("integral >=", value, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralLessThan(BigDecimal value) {
            addCriterion("integral <", value, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralLessThanOrEqualTo(BigDecimal value) {
            addCriterion("integral <=", value, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralIn(List<BigDecimal> values) {
            addCriterion("integral in", values, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralNotIn(List<BigDecimal> values) {
            addCriterion("integral not in", values, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("integral between", value1, value2, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("integral not between", value1, value2, "integral");
            return (Criteria) this;
        }

        public Criteria andGroupNameIsNull() {
            addCriterion("group_name is null");
            return (Criteria) this;
        }

        public Criteria andGroupNameIsNotNull() {
            addCriterion("group_name is not null");
            return (Criteria) this;
        }

        public Criteria andGroupNameEqualTo(String value) {
            addCriterion("group_name =", value, "groupName");
            return (Criteria) this;
        }

        public Criteria andGroupNameNotEqualTo(String value) {
            addCriterion("group_name <>", value, "groupName");
            return (Criteria) this;
        }

        public Criteria andGroupNameGreaterThan(String value) {
            addCriterion("group_name >", value, "groupName");
            return (Criteria) this;
        }

        public Criteria andGroupNameGreaterThanOrEqualTo(String value) {
            addCriterion("group_name >=", value, "groupName");
            return (Criteria) this;
        }

        public Criteria andGroupNameLessThan(String value) {
            addCriterion("group_name <", value, "groupName");
            return (Criteria) this;
        }

        public Criteria andGroupNameLessThanOrEqualTo(String value) {
            addCriterion("group_name <=", value, "groupName");
            return (Criteria) this;
        }

        public Criteria andGroupNameLike(String value) {
            addCriterion("group_name like", value, "groupName");
            return (Criteria) this;
        }

        public Criteria andGroupNameNotLike(String value) {
            addCriterion("group_name not like", value, "groupName");
            return (Criteria) this;
        }

        public Criteria andGroupNameIn(List<String> values) {
            addCriterion("group_name in", values, "groupName");
            return (Criteria) this;
        }

        public Criteria andGroupNameNotIn(List<String> values) {
            addCriterion("group_name not in", values, "groupName");
            return (Criteria) this;
        }

        public Criteria andGroupNameBetween(String value1, String value2) {
            addCriterion("group_name between", value1, value2, "groupName");
            return (Criteria) this;
        }

        public Criteria andGroupNameNotBetween(String value1, String value2) {
            addCriterion("group_name not between", value1, value2, "groupName");
            return (Criteria) this;
        }

        public Criteria andGoodsSizeNameIsNull() {
            addCriterion("goods_size_name is null");
            return (Criteria) this;
        }

        public Criteria andGoodsSizeNameIsNotNull() {
            addCriterion("goods_size_name is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsSizeNameEqualTo(String value) {
            addCriterion("goods_size_name =", value, "goodsSizeName");
            return (Criteria) this;
        }

        public Criteria andGoodsSizeNameNotEqualTo(String value) {
            addCriterion("goods_size_name <>", value, "goodsSizeName");
            return (Criteria) this;
        }

        public Criteria andGoodsSizeNameGreaterThan(String value) {
            addCriterion("goods_size_name >", value, "goodsSizeName");
            return (Criteria) this;
        }

        public Criteria andGoodsSizeNameGreaterThanOrEqualTo(String value) {
            addCriterion("goods_size_name >=", value, "goodsSizeName");
            return (Criteria) this;
        }

        public Criteria andGoodsSizeNameLessThan(String value) {
            addCriterion("goods_size_name <", value, "goodsSizeName");
            return (Criteria) this;
        }

        public Criteria andGoodsSizeNameLessThanOrEqualTo(String value) {
            addCriterion("goods_size_name <=", value, "goodsSizeName");
            return (Criteria) this;
        }

        public Criteria andGoodsSizeNameLike(String value) {
            addCriterion("goods_size_name like", value, "goodsSizeName");
            return (Criteria) this;
        }

        public Criteria andGoodsSizeNameNotLike(String value) {
            addCriterion("goods_size_name not like", value, "goodsSizeName");
            return (Criteria) this;
        }

        public Criteria andGoodsSizeNameIn(List<String> values) {
            addCriterion("goods_size_name in", values, "goodsSizeName");
            return (Criteria) this;
        }

        public Criteria andGoodsSizeNameNotIn(List<String> values) {
            addCriterion("goods_size_name not in", values, "goodsSizeName");
            return (Criteria) this;
        }

        public Criteria andGoodsSizeNameBetween(String value1, String value2) {
            addCriterion("goods_size_name between", value1, value2, "goodsSizeName");
            return (Criteria) this;
        }

        public Criteria andGoodsSizeNameNotBetween(String value1, String value2) {
            addCriterion("goods_size_name not between", value1, value2, "goodsSizeName");
            return (Criteria) this;
        }

        public Criteria andGoodsColorNameIsNull() {
            addCriterion("goods_color_name is null");
            return (Criteria) this;
        }

        public Criteria andGoodsColorNameIsNotNull() {
            addCriterion("goods_color_name is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsColorNameEqualTo(String value) {
            addCriterion("goods_color_name =", value, "goodsColorName");
            return (Criteria) this;
        }

        public Criteria andGoodsColorNameNotEqualTo(String value) {
            addCriterion("goods_color_name <>", value, "goodsColorName");
            return (Criteria) this;
        }

        public Criteria andGoodsColorNameGreaterThan(String value) {
            addCriterion("goods_color_name >", value, "goodsColorName");
            return (Criteria) this;
        }

        public Criteria andGoodsColorNameGreaterThanOrEqualTo(String value) {
            addCriterion("goods_color_name >=", value, "goodsColorName");
            return (Criteria) this;
        }

        public Criteria andGoodsColorNameLessThan(String value) {
            addCriterion("goods_color_name <", value, "goodsColorName");
            return (Criteria) this;
        }

        public Criteria andGoodsColorNameLessThanOrEqualTo(String value) {
            addCriterion("goods_color_name <=", value, "goodsColorName");
            return (Criteria) this;
        }

        public Criteria andGoodsColorNameLike(String value) {
            addCriterion("goods_color_name like", value, "goodsColorName");
            return (Criteria) this;
        }

        public Criteria andGoodsColorNameNotLike(String value) {
            addCriterion("goods_color_name not like", value, "goodsColorName");
            return (Criteria) this;
        }

        public Criteria andGoodsColorNameIn(List<String> values) {
            addCriterion("goods_color_name in", values, "goodsColorName");
            return (Criteria) this;
        }

        public Criteria andGoodsColorNameNotIn(List<String> values) {
            addCriterion("goods_color_name not in", values, "goodsColorName");
            return (Criteria) this;
        }

        public Criteria andGoodsColorNameBetween(String value1, String value2) {
            addCriterion("goods_color_name between", value1, value2, "goodsColorName");
            return (Criteria) this;
        }

        public Criteria andGoodsColorNameNotBetween(String value1, String value2) {
            addCriterion("goods_color_name not between", value1, value2, "goodsColorName");
            return (Criteria) this;
        }

        public Criteria andGoodsThumbIsNull() {
            addCriterion("goods_thumb is null");
            return (Criteria) this;
        }

        public Criteria andGoodsThumbIsNotNull() {
            addCriterion("goods_thumb is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsThumbEqualTo(String value) {
            addCriterion("goods_thumb =", value, "goodsThumb");
            return (Criteria) this;
        }

        public Criteria andGoodsThumbNotEqualTo(String value) {
            addCriterion("goods_thumb <>", value, "goodsThumb");
            return (Criteria) this;
        }

        public Criteria andGoodsThumbGreaterThan(String value) {
            addCriterion("goods_thumb >", value, "goodsThumb");
            return (Criteria) this;
        }

        public Criteria andGoodsThumbGreaterThanOrEqualTo(String value) {
            addCriterion("goods_thumb >=", value, "goodsThumb");
            return (Criteria) this;
        }

        public Criteria andGoodsThumbLessThan(String value) {
            addCriterion("goods_thumb <", value, "goodsThumb");
            return (Criteria) this;
        }

        public Criteria andGoodsThumbLessThanOrEqualTo(String value) {
            addCriterion("goods_thumb <=", value, "goodsThumb");
            return (Criteria) this;
        }

        public Criteria andGoodsThumbLike(String value) {
            addCriterion("goods_thumb like", value, "goodsThumb");
            return (Criteria) this;
        }

        public Criteria andGoodsThumbNotLike(String value) {
            addCriterion("goods_thumb not like", value, "goodsThumb");
            return (Criteria) this;
        }

        public Criteria andGoodsThumbIn(List<String> values) {
            addCriterion("goods_thumb in", values, "goodsThumb");
            return (Criteria) this;
        }

        public Criteria andGoodsThumbNotIn(List<String> values) {
            addCriterion("goods_thumb not in", values, "goodsThumb");
            return (Criteria) this;
        }

        public Criteria andGoodsThumbBetween(String value1, String value2) {
            addCriterion("goods_thumb between", value1, value2, "goodsThumb");
            return (Criteria) this;
        }

        public Criteria andGoodsThumbNotBetween(String value1, String value2) {
            addCriterion("goods_thumb not between", value1, value2, "goodsThumb");
            return (Criteria) this;
        }

        public Criteria andSendQtyIsNull() {
            addCriterion("send_qty is null");
            return (Criteria) this;
        }

        public Criteria andSendQtyIsNotNull() {
            addCriterion("send_qty is not null");
            return (Criteria) this;
        }

        public Criteria andSendQtyEqualTo(Integer value) {
            addCriterion("send_qty =", value, "sendQty");
            return (Criteria) this;
        }

        public Criteria andSendQtyNotEqualTo(Integer value) {
            addCriterion("send_qty <>", value, "sendQty");
            return (Criteria) this;
        }

        public Criteria andSendQtyGreaterThan(Integer value) {
            addCriterion("send_qty >", value, "sendQty");
            return (Criteria) this;
        }

        public Criteria andSendQtyGreaterThanOrEqualTo(Integer value) {
            addCriterion("send_qty >=", value, "sendQty");
            return (Criteria) this;
        }

        public Criteria andSendQtyLessThan(Integer value) {
            addCriterion("send_qty <", value, "sendQty");
            return (Criteria) this;
        }

        public Criteria andSendQtyLessThanOrEqualTo(Integer value) {
            addCriterion("send_qty <=", value, "sendQty");
            return (Criteria) this;
        }

        public Criteria andSendQtyIn(List<Integer> values) {
            addCriterion("send_qty in", values, "sendQty");
            return (Criteria) this;
        }

        public Criteria andSendQtyNotIn(List<Integer> values) {
            addCriterion("send_qty not in", values, "sendQty");
            return (Criteria) this;
        }

        public Criteria andSendQtyBetween(Integer value1, Integer value2) {
            addCriterion("send_qty between", value1, value2, "sendQty");
            return (Criteria) this;
        }

        public Criteria andSendQtyNotBetween(Integer value1, Integer value2) {
            addCriterion("send_qty not between", value1, value2, "sendQty");
            return (Criteria) this;
        }

        public Criteria andProductTypeNoIsNull() {
            addCriterion("product_type_no is null");
            return (Criteria) this;
        }

        public Criteria andProductTypeNoIsNotNull() {
            addCriterion("product_type_no is not null");
            return (Criteria) this;
        }

        public Criteria andProductTypeNoEqualTo(String value) {
            addCriterion("product_type_no =", value, "productTypeNo");
            return (Criteria) this;
        }

        public Criteria andProductTypeNoNotEqualTo(String value) {
            addCriterion("product_type_no <>", value, "productTypeNo");
            return (Criteria) this;
        }

        public Criteria andProductTypeNoGreaterThan(String value) {
            addCriterion("product_type_no >", value, "productTypeNo");
            return (Criteria) this;
        }

        public Criteria andProductTypeNoGreaterThanOrEqualTo(String value) {
            addCriterion("product_type_no >=", value, "productTypeNo");
            return (Criteria) this;
        }

        public Criteria andProductTypeNoLessThan(String value) {
            addCriterion("product_type_no <", value, "productTypeNo");
            return (Criteria) this;
        }

        public Criteria andProductTypeNoLessThanOrEqualTo(String value) {
            addCriterion("product_type_no <=", value, "productTypeNo");
            return (Criteria) this;
        }

        public Criteria andProductTypeNoLike(String value) {
            addCriterion("product_type_no like", value, "productTypeNo");
            return (Criteria) this;
        }

        public Criteria andProductTypeNoNotLike(String value) {
            addCriterion("product_type_no not like", value, "productTypeNo");
            return (Criteria) this;
        }

        public Criteria andProductTypeNoIn(List<String> values) {
            addCriterion("product_type_no in", values, "productTypeNo");
            return (Criteria) this;
        }

        public Criteria andProductTypeNoNotIn(List<String> values) {
            addCriterion("product_type_no not in", values, "productTypeNo");
            return (Criteria) this;
        }

        public Criteria andProductTypeNoBetween(String value1, String value2) {
            addCriterion("product_type_no between", value1, value2, "productTypeNo");
            return (Criteria) this;
        }

        public Criteria andProductTypeNoNotBetween(String value1, String value2) {
            addCriterion("product_type_no not between", value1, value2, "productTypeNo");
            return (Criteria) this;
        }

        public Criteria andExchangeFromIsNull() {
            addCriterion("exchange_from is null");
            return (Criteria) this;
        }

        public Criteria andExchangeFromIsNotNull() {
            addCriterion("exchange_from is not null");
            return (Criteria) this;
        }

        public Criteria andExchangeFromEqualTo(String value) {
            addCriterion("exchange_from =", value, "exchangeFrom");
            return (Criteria) this;
        }

        public Criteria andExchangeFromNotEqualTo(String value) {
            addCriterion("exchange_from <>", value, "exchangeFrom");
            return (Criteria) this;
        }

        public Criteria andExchangeFromGreaterThan(String value) {
            addCriterion("exchange_from >", value, "exchangeFrom");
            return (Criteria) this;
        }

        public Criteria andExchangeFromGreaterThanOrEqualTo(String value) {
            addCriterion("exchange_from >=", value, "exchangeFrom");
            return (Criteria) this;
        }

        public Criteria andExchangeFromLessThan(String value) {
            addCriterion("exchange_from <", value, "exchangeFrom");
            return (Criteria) this;
        }

        public Criteria andExchangeFromLessThanOrEqualTo(String value) {
            addCriterion("exchange_from <=", value, "exchangeFrom");
            return (Criteria) this;
        }

        public Criteria andExchangeFromLike(String value) {
            addCriterion("exchange_from like", value, "exchangeFrom");
            return (Criteria) this;
        }

        public Criteria andExchangeFromNotLike(String value) {
            addCriterion("exchange_from not like", value, "exchangeFrom");
            return (Criteria) this;
        }

        public Criteria andExchangeFromIn(List<String> values) {
            addCriterion("exchange_from in", values, "exchangeFrom");
            return (Criteria) this;
        }

        public Criteria andExchangeFromNotIn(List<String> values) {
            addCriterion("exchange_from not in", values, "exchangeFrom");
            return (Criteria) this;
        }

        public Criteria andExchangeFromBetween(String value1, String value2) {
            addCriterion("exchange_from between", value1, value2, "exchangeFrom");
            return (Criteria) this;
        }

        public Criteria andExchangeFromNotBetween(String value1, String value2) {
            addCriterion("exchange_from not between", value1, value2, "exchangeFrom");
            return (Criteria) this;
        }

        public Criteria andPromotionDescIsNull() {
            addCriterion("promotion_desc is null");
            return (Criteria) this;
        }

        public Criteria andPromotionDescIsNotNull() {
            addCriterion("promotion_desc is not null");
            return (Criteria) this;
        }

        public Criteria andPromotionDescEqualTo(String value) {
            addCriterion("promotion_desc =", value, "promotionDesc");
            return (Criteria) this;
        }

        public Criteria andPromotionDescNotEqualTo(String value) {
            addCriterion("promotion_desc <>", value, "promotionDesc");
            return (Criteria) this;
        }

        public Criteria andPromotionDescGreaterThan(String value) {
            addCriterion("promotion_desc >", value, "promotionDesc");
            return (Criteria) this;
        }

        public Criteria andPromotionDescGreaterThanOrEqualTo(String value) {
            addCriterion("promotion_desc >=", value, "promotionDesc");
            return (Criteria) this;
        }

        public Criteria andPromotionDescLessThan(String value) {
            addCriterion("promotion_desc <", value, "promotionDesc");
            return (Criteria) this;
        }

        public Criteria andPromotionDescLessThanOrEqualTo(String value) {
            addCriterion("promotion_desc <=", value, "promotionDesc");
            return (Criteria) this;
        }

        public Criteria andPromotionDescLike(String value) {
            addCriterion("promotion_desc like", value, "promotionDesc");
            return (Criteria) this;
        }

        public Criteria andPromotionDescNotLike(String value) {
            addCriterion("promotion_desc not like", value, "promotionDesc");
            return (Criteria) this;
        }

        public Criteria andPromotionDescIn(List<String> values) {
            addCriterion("promotion_desc in", values, "promotionDesc");
            return (Criteria) this;
        }

        public Criteria andPromotionDescNotIn(List<String> values) {
            addCriterion("promotion_desc not in", values, "promotionDesc");
            return (Criteria) this;
        }

        public Criteria andPromotionDescBetween(String value1, String value2) {
            addCriterion("promotion_desc between", value1, value2, "promotionDesc");
            return (Criteria) this;
        }

        public Criteria andPromotionDescNotBetween(String value1, String value2) {
            addCriterion("promotion_desc not between", value1, value2, "promotionDesc");
            return (Criteria) this;
        }

        public Criteria andPayPointsIsNull() {
            addCriterion("pay_points is null");
            return (Criteria) this;
        }

        public Criteria andPayPointsIsNotNull() {
            addCriterion("pay_points is not null");
            return (Criteria) this;
        }

        public Criteria andPayPointsEqualTo(BigDecimal value) {
            addCriterion("pay_points =", value, "payPoints");
            return (Criteria) this;
        }

        public Criteria andPayPointsNotEqualTo(BigDecimal value) {
            addCriterion("pay_points <>", value, "payPoints");
            return (Criteria) this;
        }

        public Criteria andPayPointsGreaterThan(BigDecimal value) {
            addCriterion("pay_points >", value, "payPoints");
            return (Criteria) this;
        }

        public Criteria andPayPointsGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("pay_points >=", value, "payPoints");
            return (Criteria) this;
        }

        public Criteria andPayPointsLessThan(BigDecimal value) {
            addCriterion("pay_points <", value, "payPoints");
            return (Criteria) this;
        }

        public Criteria andPayPointsLessThanOrEqualTo(BigDecimal value) {
            addCriterion("pay_points <=", value, "payPoints");
            return (Criteria) this;
        }

        public Criteria andPayPointsIn(List<BigDecimal> values) {
            addCriterion("pay_points in", values, "payPoints");
            return (Criteria) this;
        }

        public Criteria andPayPointsNotIn(List<BigDecimal> values) {
            addCriterion("pay_points not in", values, "payPoints");
            return (Criteria) this;
        }

        public Criteria andPayPointsBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pay_points between", value1, value2, "payPoints");
            return (Criteria) this;
        }

        public Criteria andPayPointsNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pay_points not between", value1, value2, "payPoints");
            return (Criteria) this;
        }

        public Criteria andUseCardIsNull() {
            addCriterion("use_card is null");
            return (Criteria) this;
        }

        public Criteria andUseCardIsNotNull() {
            addCriterion("use_card is not null");
            return (Criteria) this;
        }

        public Criteria andUseCardEqualTo(String value) {
            addCriterion("use_card =", value, "useCard");
            return (Criteria) this;
        }

        public Criteria andUseCardNotEqualTo(String value) {
            addCriterion("use_card <>", value, "useCard");
            return (Criteria) this;
        }

        public Criteria andUseCardGreaterThan(String value) {
            addCriterion("use_card >", value, "useCard");
            return (Criteria) this;
        }

        public Criteria andUseCardGreaterThanOrEqualTo(String value) {
            addCriterion("use_card >=", value, "useCard");
            return (Criteria) this;
        }

        public Criteria andUseCardLessThan(String value) {
            addCriterion("use_card <", value, "useCard");
            return (Criteria) this;
        }

        public Criteria andUseCardLessThanOrEqualTo(String value) {
            addCriterion("use_card <=", value, "useCard");
            return (Criteria) this;
        }

        public Criteria andUseCardLike(String value) {
            addCriterion("use_card like", value, "useCard");
            return (Criteria) this;
        }

        public Criteria andUseCardNotLike(String value) {
            addCriterion("use_card not like", value, "useCard");
            return (Criteria) this;
        }

        public Criteria andUseCardIn(List<String> values) {
            addCriterion("use_card in", values, "useCard");
            return (Criteria) this;
        }

        public Criteria andUseCardNotIn(List<String> values) {
            addCriterion("use_card not in", values, "useCard");
            return (Criteria) this;
        }

        public Criteria andUseCardBetween(String value1, String value2) {
            addCriterion("use_card between", value1, value2, "useCard");
            return (Criteria) this;
        }

        public Criteria andUseCardNotBetween(String value1, String value2) {
            addCriterion("use_card not between", value1, value2, "useCard");
            return (Criteria) this;
        }

        public Criteria andShareBonusIsNull() {
            addCriterion("share_bonus is null");
            return (Criteria) this;
        }

        public Criteria andShareBonusIsNotNull() {
            addCriterion("share_bonus is not null");
            return (Criteria) this;
        }

        public Criteria andShareBonusEqualTo(BigDecimal value) {
            addCriterion("share_bonus =", value, "shareBonus");
            return (Criteria) this;
        }

        public Criteria andShareBonusNotEqualTo(BigDecimal value) {
            addCriterion("share_bonus <>", value, "shareBonus");
            return (Criteria) this;
        }

        public Criteria andShareBonusGreaterThan(BigDecimal value) {
            addCriterion("share_bonus >", value, "shareBonus");
            return (Criteria) this;
        }

        public Criteria andShareBonusGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("share_bonus >=", value, "shareBonus");
            return (Criteria) this;
        }

        public Criteria andShareBonusLessThan(BigDecimal value) {
            addCriterion("share_bonus <", value, "shareBonus");
            return (Criteria) this;
        }

        public Criteria andShareBonusLessThanOrEqualTo(BigDecimal value) {
            addCriterion("share_bonus <=", value, "shareBonus");
            return (Criteria) this;
        }

        public Criteria andShareBonusIn(List<BigDecimal> values) {
            addCriterion("share_bonus in", values, "shareBonus");
            return (Criteria) this;
        }

        public Criteria andShareBonusNotIn(List<BigDecimal> values) {
            addCriterion("share_bonus not in", values, "shareBonus");
            return (Criteria) this;
        }

        public Criteria andShareBonusBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("share_bonus between", value1, value2, "shareBonus");
            return (Criteria) this;
        }

        public Criteria andShareBonusNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("share_bonus not between", value1, value2, "shareBonus");
            return (Criteria) this;
        }

        public Criteria andShareSurplusIsNull() {
            addCriterion("share_surplus is null");
            return (Criteria) this;
        }

        public Criteria andShareSurplusIsNotNull() {
            addCriterion("share_surplus is not null");
            return (Criteria) this;
        }

        public Criteria andShareSurplusEqualTo(BigDecimal value) {
            addCriterion("share_surplus =", value, "shareSurplus");
            return (Criteria) this;
        }

        public Criteria andShareSurplusNotEqualTo(BigDecimal value) {
            addCriterion("share_surplus <>", value, "shareSurplus");
            return (Criteria) this;
        }

        public Criteria andShareSurplusGreaterThan(BigDecimal value) {
            addCriterion("share_surplus >", value, "shareSurplus");
            return (Criteria) this;
        }

        public Criteria andShareSurplusGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("share_surplus >=", value, "shareSurplus");
            return (Criteria) this;
        }

        public Criteria andShareSurplusLessThan(BigDecimal value) {
            addCriterion("share_surplus <", value, "shareSurplus");
            return (Criteria) this;
        }

        public Criteria andShareSurplusLessThanOrEqualTo(BigDecimal value) {
            addCriterion("share_surplus <=", value, "shareSurplus");
            return (Criteria) this;
        }

        public Criteria andShareSurplusIn(List<BigDecimal> values) {
            addCriterion("share_surplus in", values, "shareSurplus");
            return (Criteria) this;
        }

        public Criteria andShareSurplusNotIn(List<BigDecimal> values) {
            addCriterion("share_surplus not in", values, "shareSurplus");
            return (Criteria) this;
        }

        public Criteria andShareSurplusBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("share_surplus between", value1, value2, "shareSurplus");
            return (Criteria) this;
        }

        public Criteria andShareSurplusNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("share_surplus not between", value1, value2, "shareSurplus");
            return (Criteria) this;
        }

        public Criteria andMadeFlagIsNull() {
            addCriterion("made_flag is null");
            return (Criteria) this;
        }

        public Criteria andMadeFlagIsNotNull() {
            addCriterion("made_flag is not null");
            return (Criteria) this;
        }

        public Criteria andMadeFlagEqualTo(Integer value) {
            addCriterion("made_flag =", value, "madeFlag");
            return (Criteria) this;
        }

        public Criteria andMadeFlagNotEqualTo(Integer value) {
            addCriterion("made_flag <>", value, "madeFlag");
            return (Criteria) this;
        }

        public Criteria andMadeFlagGreaterThan(Integer value) {
            addCriterion("made_flag >", value, "madeFlag");
            return (Criteria) this;
        }

        public Criteria andMadeFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("made_flag >=", value, "madeFlag");
            return (Criteria) this;
        }

        public Criteria andMadeFlagLessThan(Integer value) {
            addCriterion("made_flag <", value, "madeFlag");
            return (Criteria) this;
        }

        public Criteria andMadeFlagLessThanOrEqualTo(Integer value) {
            addCriterion("made_flag <=", value, "madeFlag");
            return (Criteria) this;
        }

        public Criteria andMadeFlagIn(List<Integer> values) {
            addCriterion("made_flag in", values, "madeFlag");
            return (Criteria) this;
        }

        public Criteria andMadeFlagNotIn(List<Integer> values) {
            addCriterion("made_flag not in", values, "madeFlag");
            return (Criteria) this;
        }

        public Criteria andMadeFlagBetween(Integer value1, Integer value2) {
            addCriterion("made_flag between", value1, value2, "madeFlag");
            return (Criteria) this;
        }

        public Criteria andMadeFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("made_flag not between", value1, value2, "madeFlag");
            return (Criteria) this;
        }

        public Criteria andReturnGoodsQtyIsNull() {
            addCriterion("return_goods_qty is null");
            return (Criteria) this;
        }

        public Criteria andReturnGoodsQtyIsNotNull() {
            addCriterion("return_goods_qty is not null");
            return (Criteria) this;
        }

        public Criteria andReturnGoodsQtyEqualTo(Integer value) {
            addCriterion("return_goods_qty =", value, "returnGoodsQty");
            return (Criteria) this;
        }

        public Criteria andReturnGoodsQtyNotEqualTo(Integer value) {
            addCriterion("return_goods_qty <>", value, "returnGoodsQty");
            return (Criteria) this;
        }

        public Criteria andReturnGoodsQtyGreaterThan(Integer value) {
            addCriterion("return_goods_qty >", value, "returnGoodsQty");
            return (Criteria) this;
        }

        public Criteria andReturnGoodsQtyGreaterThanOrEqualTo(Integer value) {
            addCriterion("return_goods_qty >=", value, "returnGoodsQty");
            return (Criteria) this;
        }

        public Criteria andReturnGoodsQtyLessThan(Integer value) {
            addCriterion("return_goods_qty <", value, "returnGoodsQty");
            return (Criteria) this;
        }

        public Criteria andReturnGoodsQtyLessThanOrEqualTo(Integer value) {
            addCriterion("return_goods_qty <=", value, "returnGoodsQty");
            return (Criteria) this;
        }

        public Criteria andReturnGoodsQtyIn(List<Integer> values) {
            addCriterion("return_goods_qty in", values, "returnGoodsQty");
            return (Criteria) this;
        }

        public Criteria andReturnGoodsQtyNotIn(List<Integer> values) {
            addCriterion("return_goods_qty not in", values, "returnGoodsQty");
            return (Criteria) this;
        }

        public Criteria andReturnGoodsQtyBetween(Integer value1, Integer value2) {
            addCriterion("return_goods_qty between", value1, value2, "returnGoodsQty");
            return (Criteria) this;
        }

        public Criteria andReturnGoodsQtyNotBetween(Integer value1, Integer value2) {
            addCriterion("return_goods_qty not between", value1, value2, "returnGoodsQty");
            return (Criteria) this;
        }

        public Criteria andReturnGoodsWeightIsNull() {
            addCriterion("return_goods_weight is null");
            return (Criteria) this;
        }

        public Criteria andReturnGoodsWeightIsNotNull() {
            addCriterion("return_goods_weight is not null");
            return (Criteria) this;
        }

        public Criteria andReturnGoodsWeightEqualTo(BigDecimal value) {
            addCriterion("return_goods_weight =", value, "returnGoodsWeight");
            return (Criteria) this;
        }

        public Criteria andReturnGoodsWeightNotEqualTo(BigDecimal value) {
            addCriterion("return_goods_weight <>", value, "returnGoodsWeight");
            return (Criteria) this;
        }

        public Criteria andReturnGoodsWeightGreaterThan(BigDecimal value) {
            addCriterion("return_goods_weight >", value, "returnGoodsWeight");
            return (Criteria) this;
        }

        public Criteria andReturnGoodsWeightGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("return_goods_weight >=", value, "returnGoodsWeight");
            return (Criteria) this;
        }

        public Criteria andReturnGoodsWeightLessThan(BigDecimal value) {
            addCriterion("return_goods_weight <", value, "returnGoodsWeight");
            return (Criteria) this;
        }

        public Criteria andReturnGoodsWeightLessThanOrEqualTo(BigDecimal value) {
            addCriterion("return_goods_weight <=", value, "returnGoodsWeight");
            return (Criteria) this;
        }

        public Criteria andReturnGoodsWeightIn(List<BigDecimal> values) {
            addCriterion("return_goods_weight in", values, "returnGoodsWeight");
            return (Criteria) this;
        }

        public Criteria andReturnGoodsWeightNotIn(List<BigDecimal> values) {
            addCriterion("return_goods_weight not in", values, "returnGoodsWeight");
            return (Criteria) this;
        }

        public Criteria andReturnGoodsWeightBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("return_goods_weight between", value1, value2, "returnGoodsWeight");
            return (Criteria) this;
        }

        public Criteria andReturnGoodsWeightNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("return_goods_weight not between", value1, value2, "returnGoodsWeight");
            return (Criteria) this;
        }

        public Criteria andIsDelIsNull() {
            addCriterion("is_del is null");
            return (Criteria) this;
        }

        public Criteria andIsDelIsNotNull() {
            addCriterion("is_del is not null");
            return (Criteria) this;
        }

        public Criteria andIsDelEqualTo(Integer value) {
            addCriterion("is_del =", value, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelNotEqualTo(Integer value) {
            addCriterion("is_del <>", value, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelGreaterThan(Integer value) {
            addCriterion("is_del >", value, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_del >=", value, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelLessThan(Integer value) {
            addCriterion("is_del <", value, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelLessThanOrEqualTo(Integer value) {
            addCriterion("is_del <=", value, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelIn(List<Integer> values) {
            addCriterion("is_del in", values, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelNotIn(List<Integer> values) {
            addCriterion("is_del not in", values, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelBetween(Integer value1, Integer value2) {
            addCriterion("is_del between", value1, value2, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelNotBetween(Integer value1, Integer value2) {
            addCriterion("is_del not between", value1, value2, "isDel");
            return (Criteria) this;
        }

        public Criteria andPromotionIdIsNull() {
            addCriterion("promotion_id is null");
            return (Criteria) this;
        }

        public Criteria andPromotionIdIsNotNull() {
            addCriterion("promotion_id is not null");
            return (Criteria) this;
        }

        public Criteria andPromotionIdEqualTo(String value) {
            addCriterion("promotion_id =", value, "promotionId");
            return (Criteria) this;
        }

        public Criteria andPromotionIdNotEqualTo(String value) {
            addCriterion("promotion_id <>", value, "promotionId");
            return (Criteria) this;
        }

        public Criteria andPromotionIdGreaterThan(String value) {
            addCriterion("promotion_id >", value, "promotionId");
            return (Criteria) this;
        }

        public Criteria andPromotionIdGreaterThanOrEqualTo(String value) {
            addCriterion("promotion_id >=", value, "promotionId");
            return (Criteria) this;
        }

        public Criteria andPromotionIdLessThan(String value) {
            addCriterion("promotion_id <", value, "promotionId");
            return (Criteria) this;
        }

        public Criteria andPromotionIdLessThanOrEqualTo(String value) {
            addCriterion("promotion_id <=", value, "promotionId");
            return (Criteria) this;
        }

        public Criteria andPromotionIdLike(String value) {
            addCriterion("promotion_id like", value, "promotionId");
            return (Criteria) this;
        }

        public Criteria andPromotionIdNotLike(String value) {
            addCriterion("promotion_id not like", value, "promotionId");
            return (Criteria) this;
        }

        public Criteria andPromotionIdIn(List<String> values) {
            addCriterion("promotion_id in", values, "promotionId");
            return (Criteria) this;
        }

        public Criteria andPromotionIdNotIn(List<String> values) {
            addCriterion("promotion_id not in", values, "promotionId");
            return (Criteria) this;
        }

        public Criteria andPromotionIdBetween(String value1, String value2) {
            addCriterion("promotion_id between", value1, value2, "promotionId");
            return (Criteria) this;
        }

        public Criteria andPromotionIdNotBetween(String value1, String value2) {
            addCriterion("promotion_id not between", value1, value2, "promotionId");
            return (Criteria) this;
        }

        public Criteria andC2mItemIsNull() {
            addCriterion("c2m_item is null");
            return (Criteria) this;
        }

        public Criteria andC2mItemIsNotNull() {
            addCriterion("c2m_item is not null");
            return (Criteria) this;
        }

        public Criteria andC2mItemEqualTo(String value) {
            addCriterion("c2m_item =", value, "c2mItem");
            return (Criteria) this;
        }

        public Criteria andC2mItemNotEqualTo(String value) {
            addCriterion("c2m_item <>", value, "c2mItem");
            return (Criteria) this;
        }

        public Criteria andC2mItemGreaterThan(String value) {
            addCriterion("c2m_item >", value, "c2mItem");
            return (Criteria) this;
        }

        public Criteria andC2mItemGreaterThanOrEqualTo(String value) {
            addCriterion("c2m_item >=", value, "c2mItem");
            return (Criteria) this;
        }

        public Criteria andC2mItemLessThan(String value) {
            addCriterion("c2m_item <", value, "c2mItem");
            return (Criteria) this;
        }

        public Criteria andC2mItemLessThanOrEqualTo(String value) {
            addCriterion("c2m_item <=", value, "c2mItem");
            return (Criteria) this;
        }

        public Criteria andC2mItemLike(String value) {
            addCriterion("c2m_item like", value, "c2mItem");
            return (Criteria) this;
        }

        public Criteria andC2mItemNotLike(String value) {
            addCriterion("c2m_item not like", value, "c2mItem");
            return (Criteria) this;
        }

        public Criteria andC2mItemIn(List<String> values) {
            addCriterion("c2m_item in", values, "c2mItem");
            return (Criteria) this;
        }

        public Criteria andC2mItemNotIn(List<String> values) {
            addCriterion("c2m_item not in", values, "c2mItem");
            return (Criteria) this;
        }

        public Criteria andC2mItemBetween(String value1, String value2) {
            addCriterion("c2m_item between", value1, value2, "c2mItem");
            return (Criteria) this;
        }

        public Criteria andC2mItemNotBetween(String value1, String value2) {
            addCriterion("c2m_item not between", value1, value2, "c2mItem");
            return (Criteria) this;
        }

        public Criteria andProtectFalgIsNull() {
            addCriterion("protect_falg is null");
            return (Criteria) this;
        }

        public Criteria andProtectFalgIsNotNull() {
            addCriterion("protect_falg is not null");
            return (Criteria) this;
        }

        public Criteria andProtectFalgEqualTo(Integer value) {
            addCriterion("protect_falg =", value, "protectFalg");
            return (Criteria) this;
        }

        public Criteria andProtectFalgNotEqualTo(Integer value) {
            addCriterion("protect_falg <>", value, "protectFalg");
            return (Criteria) this;
        }

        public Criteria andProtectFalgGreaterThan(Integer value) {
            addCriterion("protect_falg >", value, "protectFalg");
            return (Criteria) this;
        }

        public Criteria andProtectFalgGreaterThanOrEqualTo(Integer value) {
            addCriterion("protect_falg >=", value, "protectFalg");
            return (Criteria) this;
        }

        public Criteria andProtectFalgLessThan(Integer value) {
            addCriterion("protect_falg <", value, "protectFalg");
            return (Criteria) this;
        }

        public Criteria andProtectFalgLessThanOrEqualTo(Integer value) {
            addCriterion("protect_falg <=", value, "protectFalg");
            return (Criteria) this;
        }

        public Criteria andProtectFalgIn(List<Integer> values) {
            addCriterion("protect_falg in", values, "protectFalg");
            return (Criteria) this;
        }

        public Criteria andProtectFalgNotIn(List<Integer> values) {
            addCriterion("protect_falg not in", values, "protectFalg");
            return (Criteria) this;
        }

        public Criteria andProtectFalgBetween(Integer value1, Integer value2) {
            addCriterion("protect_falg between", value1, value2, "protectFalg");
            return (Criteria) this;
        }

        public Criteria andProtectFalgNotBetween(Integer value1, Integer value2) {
            addCriterion("protect_falg not between", value1, value2, "protectFalg");
            return (Criteria) this;
        }

        public Criteria andSellerCodeIsNull() {
            addCriterion("seller_code is null");
            return (Criteria) this;
        }

        public Criteria andSellerCodeIsNotNull() {
            addCriterion("seller_code is not null");
            return (Criteria) this;
        }

        public Criteria andSellerCodeEqualTo(String value) {
            addCriterion("seller_code =", value, "sellerCode");
            return (Criteria) this;
        }

        public Criteria andSellerCodeNotEqualTo(String value) {
            addCriterion("seller_code <>", value, "sellerCode");
            return (Criteria) this;
        }

        public Criteria andSellerCodeGreaterThan(String value) {
            addCriterion("seller_code >", value, "sellerCode");
            return (Criteria) this;
        }

        public Criteria andSellerCodeGreaterThanOrEqualTo(String value) {
            addCriterion("seller_code >=", value, "sellerCode");
            return (Criteria) this;
        }

        public Criteria andSellerCodeLessThan(String value) {
            addCriterion("seller_code <", value, "sellerCode");
            return (Criteria) this;
        }

        public Criteria andSellerCodeLessThanOrEqualTo(String value) {
            addCriterion("seller_code <=", value, "sellerCode");
            return (Criteria) this;
        }

        public Criteria andSellerCodeLike(String value) {
            addCriterion("seller_code like", value, "sellerCode");
            return (Criteria) this;
        }

        public Criteria andSellerCodeNotLike(String value) {
            addCriterion("seller_code not like", value, "sellerCode");
            return (Criteria) this;
        }

        public Criteria andSellerCodeIn(List<String> values) {
            addCriterion("seller_code in", values, "sellerCode");
            return (Criteria) this;
        }

        public Criteria andSellerCodeNotIn(List<String> values) {
            addCriterion("seller_code not in", values, "sellerCode");
            return (Criteria) this;
        }

        public Criteria andSellerCodeBetween(String value1, String value2) {
            addCriterion("seller_code between", value1, value2, "sellerCode");
            return (Criteria) this;
        }

        public Criteria andSellerCodeNotBetween(String value1, String value2) {
            addCriterion("seller_code not between", value1, value2, "sellerCode");
            return (Criteria) this;
        }

        public Criteria andMarketPriceIsNull() {
            addCriterion("market_price is null");
            return (Criteria) this;
        }

        public Criteria andMarketPriceIsNotNull() {
            addCriterion("market_price is not null");
            return (Criteria) this;
        }

        public Criteria andMarketPriceEqualTo(BigDecimal value) {
            addCriterion("market_price =", value, "marketPrice");
            return (Criteria) this;
        }

        public Criteria andMarketPriceNotEqualTo(BigDecimal value) {
            addCriterion("market_price <>", value, "marketPrice");
            return (Criteria) this;
        }

        public Criteria andMarketPriceGreaterThan(BigDecimal value) {
            addCriterion("market_price >", value, "marketPrice");
            return (Criteria) this;
        }

        public Criteria andMarketPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("market_price >=", value, "marketPrice");
            return (Criteria) this;
        }

        public Criteria andMarketPriceLessThan(BigDecimal value) {
            addCriterion("market_price <", value, "marketPrice");
            return (Criteria) this;
        }

        public Criteria andMarketPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("market_price <=", value, "marketPrice");
            return (Criteria) this;
        }

        public Criteria andMarketPriceIn(List<BigDecimal> values) {
            addCriterion("market_price in", values, "marketPrice");
            return (Criteria) this;
        }

        public Criteria andMarketPriceNotIn(List<BigDecimal> values) {
            addCriterion("market_price not in", values, "marketPrice");
            return (Criteria) this;
        }

        public Criteria andMarketPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("market_price between", value1, value2, "marketPrice");
            return (Criteria) this;
        }

        public Criteria andMarketPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("market_price not between", value1, value2, "marketPrice");
            return (Criteria) this;
        }

        public Criteria andSalesModeIsNull() {
            addCriterion("sales_mode is null");
            return (Criteria) this;
        }

        public Criteria andSalesModeIsNotNull() {
            addCriterion("sales_mode is not null");
            return (Criteria) this;
        }

        public Criteria andSalesModeEqualTo(Integer value) {
            addCriterion("sales_mode =", value, "salesMode");
            return (Criteria) this;
        }

        public Criteria andSalesModeNotEqualTo(Integer value) {
            addCriterion("sales_mode <>", value, "salesMode");
            return (Criteria) this;
        }

        public Criteria andSalesModeGreaterThan(Integer value) {
            addCriterion("sales_mode >", value, "salesMode");
            return (Criteria) this;
        }

        public Criteria andSalesModeGreaterThanOrEqualTo(Integer value) {
            addCriterion("sales_mode >=", value, "salesMode");
            return (Criteria) this;
        }

        public Criteria andSalesModeLessThan(Integer value) {
            addCriterion("sales_mode <", value, "salesMode");
            return (Criteria) this;
        }

        public Criteria andSalesModeLessThanOrEqualTo(Integer value) {
            addCriterion("sales_mode <=", value, "salesMode");
            return (Criteria) this;
        }

        public Criteria andSalesModeIn(List<Integer> values) {
            addCriterion("sales_mode in", values, "salesMode");
            return (Criteria) this;
        }

        public Criteria andSalesModeNotIn(List<Integer> values) {
            addCriterion("sales_mode not in", values, "salesMode");
            return (Criteria) this;
        }

        public Criteria andSalesModeBetween(Integer value1, Integer value2) {
            addCriterion("sales_mode between", value1, value2, "salesMode");
            return (Criteria) this;
        }

        public Criteria andSalesModeNotBetween(Integer value1, Integer value2) {
            addCriterion("sales_mode not between", value1, value2, "salesMode");
            return (Criteria) this;
        }

        public Criteria andTaxClassificationCodeIsNull() {
            addCriterion("tax_classification_code is null");
            return (Criteria) this;
        }

        public Criteria andTaxClassificationCodeIsNotNull() {
            addCriterion("tax_classification_code is not null");
            return (Criteria) this;
        }

        public Criteria andTaxClassificationCodeEqualTo(String value) {
            addCriterion("tax_classification_code =", value, "taxClassificationCode");
            return (Criteria) this;
        }

        public Criteria andTaxClassificationCodeNotEqualTo(String value) {
            addCriterion("tax_classification_code <>", value, "taxClassificationCode");
            return (Criteria) this;
        }

        public Criteria andTaxClassificationCodeGreaterThan(String value) {
            addCriterion("tax_classification_code >", value, "taxClassificationCode");
            return (Criteria) this;
        }

        public Criteria andTaxClassificationCodeGreaterThanOrEqualTo(String value) {
            addCriterion("tax_classification_code >=", value, "taxClassificationCode");
            return (Criteria) this;
        }

        public Criteria andTaxClassificationCodeLessThan(String value) {
            addCriterion("tax_classification_code <", value, "taxClassificationCode");
            return (Criteria) this;
        }

        public Criteria andTaxClassificationCodeLessThanOrEqualTo(String value) {
            addCriterion("tax_classification_code <=", value, "taxClassificationCode");
            return (Criteria) this;
        }

        public Criteria andTaxClassificationCodeLike(String value) {
            addCriterion("tax_classification_code like", value, "taxClassificationCode");
            return (Criteria) this;
        }

        public Criteria andTaxClassificationCodeNotLike(String value) {
            addCriterion("tax_classification_code not like", value, "taxClassificationCode");
            return (Criteria) this;
        }

        public Criteria andTaxClassificationCodeIn(List<String> values) {
            addCriterion("tax_classification_code in", values, "taxClassificationCode");
            return (Criteria) this;
        }

        public Criteria andTaxClassificationCodeNotIn(List<String> values) {
            addCriterion("tax_classification_code not in", values, "taxClassificationCode");
            return (Criteria) this;
        }

        public Criteria andTaxClassificationCodeBetween(String value1, String value2) {
            addCriterion("tax_classification_code between", value1, value2, "taxClassificationCode");
            return (Criteria) this;
        }

        public Criteria andTaxClassificationCodeNotBetween(String value1, String value2) {
            addCriterion("tax_classification_code not between", value1, value2, "taxClassificationCode");
            return (Criteria) this;
        }

        public Criteria andInputTaxIsNull() {
            addCriterion("input_tax is null");
            return (Criteria) this;
        }

        public Criteria andInputTaxIsNotNull() {
            addCriterion("input_tax is not null");
            return (Criteria) this;
        }

        public Criteria andInputTaxEqualTo(BigDecimal value) {
            addCriterion("input_tax =", value, "inputTax");
            return (Criteria) this;
        }

        public Criteria andInputTaxNotEqualTo(BigDecimal value) {
            addCriterion("input_tax <>", value, "inputTax");
            return (Criteria) this;
        }

        public Criteria andInputTaxGreaterThan(BigDecimal value) {
            addCriterion("input_tax >", value, "inputTax");
            return (Criteria) this;
        }

        public Criteria andInputTaxGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("input_tax >=", value, "inputTax");
            return (Criteria) this;
        }

        public Criteria andInputTaxLessThan(BigDecimal value) {
            addCriterion("input_tax <", value, "inputTax");
            return (Criteria) this;
        }

        public Criteria andInputTaxLessThanOrEqualTo(BigDecimal value) {
            addCriterion("input_tax <=", value, "inputTax");
            return (Criteria) this;
        }

        public Criteria andInputTaxIn(List<BigDecimal> values) {
            addCriterion("input_tax in", values, "inputTax");
            return (Criteria) this;
        }

        public Criteria andInputTaxNotIn(List<BigDecimal> values) {
            addCriterion("input_tax not in", values, "inputTax");
            return (Criteria) this;
        }

        public Criteria andInputTaxBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("input_tax between", value1, value2, "inputTax");
            return (Criteria) this;
        }

        public Criteria andInputTaxNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("input_tax not between", value1, value2, "inputTax");
            return (Criteria) this;
        }

        public Criteria andOutputTaxIsNull() {
            addCriterion("output_tax is null");
            return (Criteria) this;
        }

        public Criteria andOutputTaxIsNotNull() {
            addCriterion("output_tax is not null");
            return (Criteria) this;
        }

        public Criteria andOutputTaxEqualTo(BigDecimal value) {
            addCriterion("output_tax =", value, "outputTax");
            return (Criteria) this;
        }

        public Criteria andOutputTaxNotEqualTo(BigDecimal value) {
            addCriterion("output_tax <>", value, "outputTax");
            return (Criteria) this;
        }

        public Criteria andOutputTaxGreaterThan(BigDecimal value) {
            addCriterion("output_tax >", value, "outputTax");
            return (Criteria) this;
        }

        public Criteria andOutputTaxGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("output_tax >=", value, "outputTax");
            return (Criteria) this;
        }

        public Criteria andOutputTaxLessThan(BigDecimal value) {
            addCriterion("output_tax <", value, "outputTax");
            return (Criteria) this;
        }

        public Criteria andOutputTaxLessThanOrEqualTo(BigDecimal value) {
            addCriterion("output_tax <=", value, "outputTax");
            return (Criteria) this;
        }

        public Criteria andOutputTaxIn(List<BigDecimal> values) {
            addCriterion("output_tax in", values, "outputTax");
            return (Criteria) this;
        }

        public Criteria andOutputTaxNotIn(List<BigDecimal> values) {
            addCriterion("output_tax not in", values, "outputTax");
            return (Criteria) this;
        }

        public Criteria andOutputTaxBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("output_tax between", value1, value2, "outputTax");
            return (Criteria) this;
        }

        public Criteria andOutputTaxNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("output_tax not between", value1, value2, "outputTax");
            return (Criteria) this;
        }

        public Criteria andCostPriceIsNull() {
            addCriterion("cost_price is null");
            return (Criteria) this;
        }

        public Criteria andCostPriceIsNotNull() {
            addCriterion("cost_price is not null");
            return (Criteria) this;
        }

        public Criteria andCostPriceEqualTo(BigDecimal value) {
            addCriterion("cost_price =", value, "costPrice");
            return (Criteria) this;
        }

        public Criteria andCostPriceNotEqualTo(BigDecimal value) {
            addCriterion("cost_price <>", value, "costPrice");
            return (Criteria) this;
        }

        public Criteria andCostPriceGreaterThan(BigDecimal value) {
            addCriterion("cost_price >", value, "costPrice");
            return (Criteria) this;
        }

        public Criteria andCostPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("cost_price >=", value, "costPrice");
            return (Criteria) this;
        }

        public Criteria andCostPriceLessThan(BigDecimal value) {
            addCriterion("cost_price <", value, "costPrice");
            return (Criteria) this;
        }

        public Criteria andCostPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("cost_price <=", value, "costPrice");
            return (Criteria) this;
        }

        public Criteria andCostPriceIn(List<BigDecimal> values) {
            addCriterion("cost_price in", values, "costPrice");
            return (Criteria) this;
        }

        public Criteria andCostPriceNotIn(List<BigDecimal> values) {
            addCriterion("cost_price not in", values, "costPrice");
            return (Criteria) this;
        }

        public Criteria andCostPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("cost_price between", value1, value2, "costPrice");
            return (Criteria) this;
        }

        public Criteria andCostPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("cost_price not between", value1, value2, "costPrice");
            return (Criteria) this;
        }

        public Criteria andShippingPriceIsNull() {
            addCriterion("shipping_price is null");
            return (Criteria) this;
        }

        public Criteria andShippingPriceIsNotNull() {
            addCriterion("shipping_price is not null");
            return (Criteria) this;
        }

        public Criteria andShippingPriceEqualTo(BigDecimal value) {
            addCriterion("shipping_price =", value, "shippingPrice");
            return (Criteria) this;
        }

        public Criteria andShippingPriceNotEqualTo(BigDecimal value) {
            addCriterion("shipping_price <>", value, "shippingPrice");
            return (Criteria) this;
        }

        public Criteria andShippingPriceGreaterThan(BigDecimal value) {
            addCriterion("shipping_price >", value, "shippingPrice");
            return (Criteria) this;
        }

        public Criteria andShippingPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("shipping_price >=", value, "shippingPrice");
            return (Criteria) this;
        }

        public Criteria andShippingPriceLessThan(BigDecimal value) {
            addCriterion("shipping_price <", value, "shippingPrice");
            return (Criteria) this;
        }

        public Criteria andShippingPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("shipping_price <=", value, "shippingPrice");
            return (Criteria) this;
        }

        public Criteria andShippingPriceIn(List<BigDecimal> values) {
            addCriterion("shipping_price in", values, "shippingPrice");
            return (Criteria) this;
        }

        public Criteria andShippingPriceNotIn(List<BigDecimal> values) {
            addCriterion("shipping_price not in", values, "shippingPrice");
            return (Criteria) this;
        }

        public Criteria andShippingPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("shipping_price between", value1, value2, "shippingPrice");
            return (Criteria) this;
        }

        public Criteria andShippingPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("shipping_price not between", value1, value2, "shippingPrice");
            return (Criteria) this;
        }

        public Criteria andUnitTitleIsNull() {
            addCriterion("unit_title is null");
            return (Criteria) this;
        }

        public Criteria andUnitTitleIsNotNull() {
            addCriterion("unit_title is not null");
            return (Criteria) this;
        }

        public Criteria andUnitTitleEqualTo(String value) {
            addCriterion("unit_title =", value, "unitTitle");
            return (Criteria) this;
        }

        public Criteria andUnitTitleNotEqualTo(String value) {
            addCriterion("unit_title <>", value, "unitTitle");
            return (Criteria) this;
        }

        public Criteria andUnitTitleGreaterThan(String value) {
            addCriterion("unit_title >", value, "unitTitle");
            return (Criteria) this;
        }

        public Criteria andUnitTitleGreaterThanOrEqualTo(String value) {
            addCriterion("unit_title >=", value, "unitTitle");
            return (Criteria) this;
        }

        public Criteria andUnitTitleLessThan(String value) {
            addCriterion("unit_title <", value, "unitTitle");
            return (Criteria) this;
        }

        public Criteria andUnitTitleLessThanOrEqualTo(String value) {
            addCriterion("unit_title <=", value, "unitTitle");
            return (Criteria) this;
        }

        public Criteria andUnitTitleLike(String value) {
            addCriterion("unit_title like", value, "unitTitle");
            return (Criteria) this;
        }

        public Criteria andUnitTitleNotLike(String value) {
            addCriterion("unit_title not like", value, "unitTitle");
            return (Criteria) this;
        }

        public Criteria andUnitTitleIn(List<String> values) {
            addCriterion("unit_title in", values, "unitTitle");
            return (Criteria) this;
        }

        public Criteria andUnitTitleNotIn(List<String> values) {
            addCriterion("unit_title not in", values, "unitTitle");
            return (Criteria) this;
        }

        public Criteria andUnitTitleBetween(String value1, String value2) {
            addCriterion("unit_title between", value1, value2, "unitTitle");
            return (Criteria) this;
        }

        public Criteria andUnitTitleNotBetween(String value1, String value2) {
            addCriterion("unit_title not between", value1, value2, "unitTitle");
            return (Criteria) this;
        }

        public Criteria andDeliveryCycleIsNull() {
            addCriterion("delivery_cycle is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryCycleIsNotNull() {
            addCriterion("delivery_cycle is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryCycleEqualTo(Integer value) {
            addCriterion("delivery_cycle =", value, "deliveryCycle");
            return (Criteria) this;
        }

        public Criteria andDeliveryCycleNotEqualTo(Integer value) {
            addCriterion("delivery_cycle <>", value, "deliveryCycle");
            return (Criteria) this;
        }

        public Criteria andDeliveryCycleGreaterThan(Integer value) {
            addCriterion("delivery_cycle >", value, "deliveryCycle");
            return (Criteria) this;
        }

        public Criteria andDeliveryCycleGreaterThanOrEqualTo(Integer value) {
            addCriterion("delivery_cycle >=", value, "deliveryCycle");
            return (Criteria) this;
        }

        public Criteria andDeliveryCycleLessThan(Integer value) {
            addCriterion("delivery_cycle <", value, "deliveryCycle");
            return (Criteria) this;
        }

        public Criteria andDeliveryCycleLessThanOrEqualTo(Integer value) {
            addCriterion("delivery_cycle <=", value, "deliveryCycle");
            return (Criteria) this;
        }

        public Criteria andDeliveryCycleIn(List<Integer> values) {
            addCriterion("delivery_cycle in", values, "deliveryCycle");
            return (Criteria) this;
        }

        public Criteria andDeliveryCycleNotIn(List<Integer> values) {
            addCriterion("delivery_cycle not in", values, "deliveryCycle");
            return (Criteria) this;
        }

        public Criteria andDeliveryCycleBetween(Integer value1, Integer value2) {
            addCriterion("delivery_cycle between", value1, value2, "deliveryCycle");
            return (Criteria) this;
        }

        public Criteria andDeliveryCycleNotBetween(Integer value1, Integer value2) {
            addCriterion("delivery_cycle not between", value1, value2, "deliveryCycle");
            return (Criteria) this;
        }

        public Criteria andExpectedShipTimeIsNull() {
            addCriterion("expected_ship_time is null");
            return (Criteria) this;
        }

        public Criteria andExpectedShipTimeIsNotNull() {
            addCriterion("expected_ship_time is not null");
            return (Criteria) this;
        }

        public Criteria andExpectedShipTimeEqualTo(Date value) {
            addCriterion("expected_ship_time =", value, "expectedShipTime");
            return (Criteria) this;
        }

        public Criteria andExpectedShipTimeNotEqualTo(Date value) {
            addCriterion("expected_ship_time <>", value, "expectedShipTime");
            return (Criteria) this;
        }

        public Criteria andExpectedShipTimeGreaterThan(Date value) {
            addCriterion("expected_ship_time >", value, "expectedShipTime");
            return (Criteria) this;
        }

        public Criteria andExpectedShipTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("expected_ship_time >=", value, "expectedShipTime");
            return (Criteria) this;
        }

        public Criteria andExpectedShipTimeLessThan(Date value) {
            addCriterion("expected_ship_time <", value, "expectedShipTime");
            return (Criteria) this;
        }

        public Criteria andExpectedShipTimeLessThanOrEqualTo(Date value) {
            addCriterion("expected_ship_time <=", value, "expectedShipTime");
            return (Criteria) this;
        }

        public Criteria andExpectedShipTimeIn(List<Date> values) {
            addCriterion("expected_ship_time in", values, "expectedShipTime");
            return (Criteria) this;
        }

        public Criteria andExpectedShipTimeNotIn(List<Date> values) {
            addCriterion("expected_ship_time not in", values, "expectedShipTime");
            return (Criteria) this;
        }

        public Criteria andExpectedShipTimeBetween(Date value1, Date value2) {
            addCriterion("expected_ship_time between", value1, value2, "expectedShipTime");
            return (Criteria) this;
        }

        public Criteria andExpectedShipTimeNotBetween(Date value1, Date value2) {
            addCriterion("expected_ship_time not between", value1, value2, "expectedShipTime");
            return (Criteria) this;
        }

        public Criteria andGoodsExtraPriceIsNull() {
            addCriterion("goods_extra_price is null");
            return (Criteria) this;
        }

        public Criteria andGoodsExtraPriceIsNotNull() {
            addCriterion("goods_extra_price is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsExtraPriceEqualTo(BigDecimal value) {
            addCriterion("goods_extra_price =", value, "goodsExtraPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsExtraPriceNotEqualTo(BigDecimal value) {
            addCriterion("goods_extra_price <>", value, "goodsExtraPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsExtraPriceGreaterThan(BigDecimal value) {
            addCriterion("goods_extra_price >", value, "goodsExtraPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsExtraPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("goods_extra_price >=", value, "goodsExtraPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsExtraPriceLessThan(BigDecimal value) {
            addCriterion("goods_extra_price <", value, "goodsExtraPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsExtraPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("goods_extra_price <=", value, "goodsExtraPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsExtraPriceIn(List<BigDecimal> values) {
            addCriterion("goods_extra_price in", values, "goodsExtraPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsExtraPriceNotIn(List<BigDecimal> values) {
            addCriterion("goods_extra_price not in", values, "goodsExtraPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsExtraPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("goods_extra_price between", value1, value2, "goodsExtraPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsExtraPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("goods_extra_price not between", value1, value2, "goodsExtraPrice");
            return (Criteria) this;
        }

        public Criteria andProductApnnoIsNull() {
            addCriterion("product_apnno is null");
            return (Criteria) this;
        }

        public Criteria andProductApnnoIsNotNull() {
            addCriterion("product_apnno is not null");
            return (Criteria) this;
        }

        public Criteria andProductApnnoEqualTo(String value) {
            addCriterion("product_apnno =", value, "productApnno");
            return (Criteria) this;
        }

        public Criteria andProductApnnoNotEqualTo(String value) {
            addCriterion("product_apnno <>", value, "productApnno");
            return (Criteria) this;
        }

        public Criteria andProductApnnoGreaterThan(String value) {
            addCriterion("product_apnno >", value, "productApnno");
            return (Criteria) this;
        }

        public Criteria andProductApnnoGreaterThanOrEqualTo(String value) {
            addCriterion("product_apnno >=", value, "productApnno");
            return (Criteria) this;
        }

        public Criteria andProductApnnoLessThan(String value) {
            addCriterion("product_apnno <", value, "productApnno");
            return (Criteria) this;
        }

        public Criteria andProductApnnoLessThanOrEqualTo(String value) {
            addCriterion("product_apnno <=", value, "productApnno");
            return (Criteria) this;
        }

        public Criteria andProductApnnoLike(String value) {
            addCriterion("product_apnno like", value, "productApnno");
            return (Criteria) this;
        }

        public Criteria andProductApnnoNotLike(String value) {
            addCriterion("product_apnno not like", value, "productApnno");
            return (Criteria) this;
        }

        public Criteria andProductApnnoIn(List<String> values) {
            addCriterion("product_apnno in", values, "productApnno");
            return (Criteria) this;
        }

        public Criteria andProductApnnoNotIn(List<String> values) {
            addCriterion("product_apnno not in", values, "productApnno");
            return (Criteria) this;
        }

        public Criteria andProductApnnoBetween(String value1, String value2) {
            addCriterion("product_apnno between", value1, value2, "productApnno");
            return (Criteria) this;
        }

        public Criteria andProductApnnoNotBetween(String value1, String value2) {
            addCriterion("product_apnno not between", value1, value2, "productApnno");
            return (Criteria) this;
        }

        public Criteria andProductTradenoIsNull() {
            addCriterion("product_tradeno is null");
            return (Criteria) this;
        }

        public Criteria andProductTradenoIsNotNull() {
            addCriterion("product_tradeno is not null");
            return (Criteria) this;
        }

        public Criteria andProductTradenoEqualTo(String value) {
            addCriterion("product_tradeno =", value, "productTradeno");
            return (Criteria) this;
        }

        public Criteria andProductTradenoNotEqualTo(String value) {
            addCriterion("product_tradeno <>", value, "productTradeno");
            return (Criteria) this;
        }

        public Criteria andProductTradenoGreaterThan(String value) {
            addCriterion("product_tradeno >", value, "productTradeno");
            return (Criteria) this;
        }

        public Criteria andProductTradenoGreaterThanOrEqualTo(String value) {
            addCriterion("product_tradeno >=", value, "productTradeno");
            return (Criteria) this;
        }

        public Criteria andProductTradenoLessThan(String value) {
            addCriterion("product_tradeno <", value, "productTradeno");
            return (Criteria) this;
        }

        public Criteria andProductTradenoLessThanOrEqualTo(String value) {
            addCriterion("product_tradeno <=", value, "productTradeno");
            return (Criteria) this;
        }

        public Criteria andProductTradenoLike(String value) {
            addCriterion("product_tradeno like", value, "productTradeno");
            return (Criteria) this;
        }

        public Criteria andProductTradenoNotLike(String value) {
            addCriterion("product_tradeno not like", value, "productTradeno");
            return (Criteria) this;
        }

        public Criteria andProductTradenoIn(List<String> values) {
            addCriterion("product_tradeno in", values, "productTradeno");
            return (Criteria) this;
        }

        public Criteria andProductTradenoNotIn(List<String> values) {
            addCriterion("product_tradeno not in", values, "productTradeno");
            return (Criteria) this;
        }

        public Criteria andProductTradenoBetween(String value1, String value2) {
            addCriterion("product_tradeno between", value1, value2, "productTradeno");
            return (Criteria) this;
        }

        public Criteria andProductTradenoNotBetween(String value1, String value2) {
            addCriterion("product_tradeno not between", value1, value2, "productTradeno");
            return (Criteria) this;
        }

        public Criteria andProductGradeIsNull() {
            addCriterion("product_grade is null");
            return (Criteria) this;
        }

        public Criteria andProductGradeIsNotNull() {
            addCriterion("product_grade is not null");
            return (Criteria) this;
        }

        public Criteria andProductGradeEqualTo(String value) {
            addCriterion("product_grade =", value, "productGrade");
            return (Criteria) this;
        }

        public Criteria andProductGradeNotEqualTo(String value) {
            addCriterion("product_grade <>", value, "productGrade");
            return (Criteria) this;
        }

        public Criteria andProductGradeGreaterThan(String value) {
            addCriterion("product_grade >", value, "productGrade");
            return (Criteria) this;
        }

        public Criteria andProductGradeGreaterThanOrEqualTo(String value) {
            addCriterion("product_grade >=", value, "productGrade");
            return (Criteria) this;
        }

        public Criteria andProductGradeLessThan(String value) {
            addCriterion("product_grade <", value, "productGrade");
            return (Criteria) this;
        }

        public Criteria andProductGradeLessThanOrEqualTo(String value) {
            addCriterion("product_grade <=", value, "productGrade");
            return (Criteria) this;
        }

        public Criteria andProductGradeLike(String value) {
            addCriterion("product_grade like", value, "productGrade");
            return (Criteria) this;
        }

        public Criteria andProductGradeNotLike(String value) {
            addCriterion("product_grade not like", value, "productGrade");
            return (Criteria) this;
        }

        public Criteria andProductGradeIn(List<String> values) {
            addCriterion("product_grade in", values, "productGrade");
            return (Criteria) this;
        }

        public Criteria andProductGradeNotIn(List<String> values) {
            addCriterion("product_grade not in", values, "productGrade");
            return (Criteria) this;
        }

        public Criteria andProductGradeBetween(String value1, String value2) {
            addCriterion("product_grade between", value1, value2, "productGrade");
            return (Criteria) this;
        }

        public Criteria andProductGradeNotBetween(String value1, String value2) {
            addCriterion("product_grade not between", value1, value2, "productGrade");
            return (Criteria) this;
        }

        public Criteria andProductThickIsNull() {
            addCriterion("product_thick is null");
            return (Criteria) this;
        }

        public Criteria andProductThickIsNotNull() {
            addCriterion("product_thick is not null");
            return (Criteria) this;
        }

        public Criteria andProductThickEqualTo(BigDecimal value) {
            addCriterion("product_thick =", value, "productThick");
            return (Criteria) this;
        }

        public Criteria andProductThickNotEqualTo(BigDecimal value) {
            addCriterion("product_thick <>", value, "productThick");
            return (Criteria) this;
        }

        public Criteria andProductThickGreaterThan(BigDecimal value) {
            addCriterion("product_thick >", value, "productThick");
            return (Criteria) this;
        }

        public Criteria andProductThickGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("product_thick >=", value, "productThick");
            return (Criteria) this;
        }

        public Criteria andProductThickLessThan(BigDecimal value) {
            addCriterion("product_thick <", value, "productThick");
            return (Criteria) this;
        }

        public Criteria andProductThickLessThanOrEqualTo(BigDecimal value) {
            addCriterion("product_thick <=", value, "productThick");
            return (Criteria) this;
        }

        public Criteria andProductThickIn(List<BigDecimal> values) {
            addCriterion("product_thick in", values, "productThick");
            return (Criteria) this;
        }

        public Criteria andProductThickNotIn(List<BigDecimal> values) {
            addCriterion("product_thick not in", values, "productThick");
            return (Criteria) this;
        }

        public Criteria andProductThickBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("product_thick between", value1, value2, "productThick");
            return (Criteria) this;
        }

        public Criteria andProductThickNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("product_thick not between", value1, value2, "productThick");
            return (Criteria) this;
        }

        public Criteria andProductLenIsNull() {
            addCriterion("product_len is null");
            return (Criteria) this;
        }

        public Criteria andProductLenIsNotNull() {
            addCriterion("product_len is not null");
            return (Criteria) this;
        }

        public Criteria andProductLenEqualTo(BigDecimal value) {
            addCriterion("product_len =", value, "productLen");
            return (Criteria) this;
        }

        public Criteria andProductLenNotEqualTo(BigDecimal value) {
            addCriterion("product_len <>", value, "productLen");
            return (Criteria) this;
        }

        public Criteria andProductLenGreaterThan(BigDecimal value) {
            addCriterion("product_len >", value, "productLen");
            return (Criteria) this;
        }

        public Criteria andProductLenGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("product_len >=", value, "productLen");
            return (Criteria) this;
        }

        public Criteria andProductLenLessThan(BigDecimal value) {
            addCriterion("product_len <", value, "productLen");
            return (Criteria) this;
        }

        public Criteria andProductLenLessThanOrEqualTo(BigDecimal value) {
            addCriterion("product_len <=", value, "productLen");
            return (Criteria) this;
        }

        public Criteria andProductLenIn(List<BigDecimal> values) {
            addCriterion("product_len in", values, "productLen");
            return (Criteria) this;
        }

        public Criteria andProductLenNotIn(List<BigDecimal> values) {
            addCriterion("product_len not in", values, "productLen");
            return (Criteria) this;
        }

        public Criteria andProductLenBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("product_len between", value1, value2, "productLen");
            return (Criteria) this;
        }

        public Criteria andProductLenNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("product_len not between", value1, value2, "productLen");
            return (Criteria) this;
        }

        public Criteria andProductWidthIsNull() {
            addCriterion("product_width is null");
            return (Criteria) this;
        }

        public Criteria andProductWidthIsNotNull() {
            addCriterion("product_width is not null");
            return (Criteria) this;
        }

        public Criteria andProductWidthEqualTo(BigDecimal value) {
            addCriterion("product_width =", value, "productWidth");
            return (Criteria) this;
        }

        public Criteria andProductWidthNotEqualTo(BigDecimal value) {
            addCriterion("product_width <>", value, "productWidth");
            return (Criteria) this;
        }

        public Criteria andProductWidthGreaterThan(BigDecimal value) {
            addCriterion("product_width >", value, "productWidth");
            return (Criteria) this;
        }

        public Criteria andProductWidthGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("product_width >=", value, "productWidth");
            return (Criteria) this;
        }

        public Criteria andProductWidthLessThan(BigDecimal value) {
            addCriterion("product_width <", value, "productWidth");
            return (Criteria) this;
        }

        public Criteria andProductWidthLessThanOrEqualTo(BigDecimal value) {
            addCriterion("product_width <=", value, "productWidth");
            return (Criteria) this;
        }

        public Criteria andProductWidthIn(List<BigDecimal> values) {
            addCriterion("product_width in", values, "productWidth");
            return (Criteria) this;
        }

        public Criteria andProductWidthNotIn(List<BigDecimal> values) {
            addCriterion("product_width not in", values, "productWidth");
            return (Criteria) this;
        }

        public Criteria andProductWidthBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("product_width between", value1, value2, "productWidth");
            return (Criteria) this;
        }

        public Criteria andProductWidthNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("product_width not between", value1, value2, "productWidth");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMinIsNull() {
            addCriterion("order_length_min is null");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMinIsNotNull() {
            addCriterion("order_length_min is not null");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMinEqualTo(BigDecimal value) {
            addCriterion("order_length_min =", value, "orderLengthMin");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMinNotEqualTo(BigDecimal value) {
            addCriterion("order_length_min <>", value, "orderLengthMin");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMinGreaterThan(BigDecimal value) {
            addCriterion("order_length_min >", value, "orderLengthMin");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMinGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("order_length_min >=", value, "orderLengthMin");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMinLessThan(BigDecimal value) {
            addCriterion("order_length_min <", value, "orderLengthMin");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMinLessThanOrEqualTo(BigDecimal value) {
            addCriterion("order_length_min <=", value, "orderLengthMin");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMinIn(List<BigDecimal> values) {
            addCriterion("order_length_min in", values, "orderLengthMin");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMinNotIn(List<BigDecimal> values) {
            addCriterion("order_length_min not in", values, "orderLengthMin");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMinBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_length_min between", value1, value2, "orderLengthMin");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMinNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_length_min not between", value1, value2, "orderLengthMin");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMaxIsNull() {
            addCriterion("order_length_max is null");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMaxIsNotNull() {
            addCriterion("order_length_max is not null");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMaxEqualTo(BigDecimal value) {
            addCriterion("order_length_max =", value, "orderLengthMax");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMaxNotEqualTo(BigDecimal value) {
            addCriterion("order_length_max <>", value, "orderLengthMax");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMaxGreaterThan(BigDecimal value) {
            addCriterion("order_length_max >", value, "orderLengthMax");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMaxGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("order_length_max >=", value, "orderLengthMax");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMaxLessThan(BigDecimal value) {
            addCriterion("order_length_max <", value, "orderLengthMax");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMaxLessThanOrEqualTo(BigDecimal value) {
            addCriterion("order_length_max <=", value, "orderLengthMax");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMaxIn(List<BigDecimal> values) {
            addCriterion("order_length_max in", values, "orderLengthMax");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMaxNotIn(List<BigDecimal> values) {
            addCriterion("order_length_max not in", values, "orderLengthMax");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMaxBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_length_max between", value1, value2, "orderLengthMax");
            return (Criteria) this;
        }

        public Criteria andOrderLengthMaxNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_length_max not between", value1, value2, "orderLengthMax");
            return (Criteria) this;
        }

        public Criteria andProductWgtIsNull() {
            addCriterion("product_wgt is null");
            return (Criteria) this;
        }

        public Criteria andProductWgtIsNotNull() {
            addCriterion("product_wgt is not null");
            return (Criteria) this;
        }

        public Criteria andProductWgtEqualTo(BigDecimal value) {
            addCriterion("product_wgt =", value, "productWgt");
            return (Criteria) this;
        }

        public Criteria andProductWgtNotEqualTo(BigDecimal value) {
            addCriterion("product_wgt <>", value, "productWgt");
            return (Criteria) this;
        }

        public Criteria andProductWgtGreaterThan(BigDecimal value) {
            addCriterion("product_wgt >", value, "productWgt");
            return (Criteria) this;
        }

        public Criteria andProductWgtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("product_wgt >=", value, "productWgt");
            return (Criteria) this;
        }

        public Criteria andProductWgtLessThan(BigDecimal value) {
            addCriterion("product_wgt <", value, "productWgt");
            return (Criteria) this;
        }

        public Criteria andProductWgtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("product_wgt <=", value, "productWgt");
            return (Criteria) this;
        }

        public Criteria andProductWgtIn(List<BigDecimal> values) {
            addCriterion("product_wgt in", values, "productWgt");
            return (Criteria) this;
        }

        public Criteria andProductWgtNotIn(List<BigDecimal> values) {
            addCriterion("product_wgt not in", values, "productWgt");
            return (Criteria) this;
        }

        public Criteria andProductWgtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("product_wgt between", value1, value2, "productWgt");
            return (Criteria) this;
        }

        public Criteria andProductWgtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("product_wgt not between", value1, value2, "productWgt");
            return (Criteria) this;
        }

        public Criteria andProductSizeMsgIsNull() {
            addCriterion("product_size_msg is null");
            return (Criteria) this;
        }

        public Criteria andProductSizeMsgIsNotNull() {
            addCriterion("product_size_msg is not null");
            return (Criteria) this;
        }

        public Criteria andProductSizeMsgEqualTo(String value) {
            addCriterion("product_size_msg =", value, "productSizeMsg");
            return (Criteria) this;
        }

        public Criteria andProductSizeMsgNotEqualTo(String value) {
            addCriterion("product_size_msg <>", value, "productSizeMsg");
            return (Criteria) this;
        }

        public Criteria andProductSizeMsgGreaterThan(String value) {
            addCriterion("product_size_msg >", value, "productSizeMsg");
            return (Criteria) this;
        }

        public Criteria andProductSizeMsgGreaterThanOrEqualTo(String value) {
            addCriterion("product_size_msg >=", value, "productSizeMsg");
            return (Criteria) this;
        }

        public Criteria andProductSizeMsgLessThan(String value) {
            addCriterion("product_size_msg <", value, "productSizeMsg");
            return (Criteria) this;
        }

        public Criteria andProductSizeMsgLessThanOrEqualTo(String value) {
            addCriterion("product_size_msg <=", value, "productSizeMsg");
            return (Criteria) this;
        }

        public Criteria andProductSizeMsgLike(String value) {
            addCriterion("product_size_msg like", value, "productSizeMsg");
            return (Criteria) this;
        }

        public Criteria andProductSizeMsgNotLike(String value) {
            addCriterion("product_size_msg not like", value, "productSizeMsg");
            return (Criteria) this;
        }

        public Criteria andProductSizeMsgIn(List<String> values) {
            addCriterion("product_size_msg in", values, "productSizeMsg");
            return (Criteria) this;
        }

        public Criteria andProductSizeMsgNotIn(List<String> values) {
            addCriterion("product_size_msg not in", values, "productSizeMsg");
            return (Criteria) this;
        }

        public Criteria andProductSizeMsgBetween(String value1, String value2) {
            addCriterion("product_size_msg between", value1, value2, "productSizeMsg");
            return (Criteria) this;
        }

        public Criteria andProductSizeMsgNotBetween(String value1, String value2) {
            addCriterion("product_size_msg not between", value1, value2, "productSizeMsg");
            return (Criteria) this;
        }

        public Criteria andShippingFeeIsNull() {
            addCriterion("shipping_fee is null");
            return (Criteria) this;
        }

        public Criteria andShippingFeeIsNotNull() {
            addCriterion("shipping_fee is not null");
            return (Criteria) this;
        }

        public Criteria andShippingFeeEqualTo(BigDecimal value) {
            addCriterion("shipping_fee =", value, "shippingFee");
            return (Criteria) this;
        }

        public Criteria andShippingFeeNotEqualTo(BigDecimal value) {
            addCriterion("shipping_fee <>", value, "shippingFee");
            return (Criteria) this;
        }

        public Criteria andShippingFeeGreaterThan(BigDecimal value) {
            addCriterion("shipping_fee >", value, "shippingFee");
            return (Criteria) this;
        }

        public Criteria andShippingFeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("shipping_fee >=", value, "shippingFee");
            return (Criteria) this;
        }

        public Criteria andShippingFeeLessThan(BigDecimal value) {
            addCriterion("shipping_fee <", value, "shippingFee");
            return (Criteria) this;
        }

        public Criteria andShippingFeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("shipping_fee <=", value, "shippingFee");
            return (Criteria) this;
        }

        public Criteria andShippingFeeIn(List<BigDecimal> values) {
            addCriterion("shipping_fee in", values, "shippingFee");
            return (Criteria) this;
        }

        public Criteria andShippingFeeNotIn(List<BigDecimal> values) {
            addCriterion("shipping_fee not in", values, "shippingFee");
            return (Criteria) this;
        }

        public Criteria andShippingFeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("shipping_fee between", value1, value2, "shippingFee");
            return (Criteria) this;
        }

        public Criteria andShippingFeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("shipping_fee not between", value1, value2, "shippingFee");
            return (Criteria) this;
        }

        public Criteria andBasicAttrIsNull() {
            addCriterion("basic_attr is null");
            return (Criteria) this;
        }

        public Criteria andBasicAttrIsNotNull() {
            addCriterion("basic_attr is not null");
            return (Criteria) this;
        }

        public Criteria andBasicAttrEqualTo(String value) {
            addCriterion("basic_attr =", value, "basicAttr");
            return (Criteria) this;
        }

        public Criteria andBasicAttrNotEqualTo(String value) {
            addCriterion("basic_attr <>", value, "basicAttr");
            return (Criteria) this;
        }

        public Criteria andBasicAttrGreaterThan(String value) {
            addCriterion("basic_attr >", value, "basicAttr");
            return (Criteria) this;
        }

        public Criteria andBasicAttrGreaterThanOrEqualTo(String value) {
            addCriterion("basic_attr >=", value, "basicAttr");
            return (Criteria) this;
        }

        public Criteria andBasicAttrLessThan(String value) {
            addCriterion("basic_attr <", value, "basicAttr");
            return (Criteria) this;
        }

        public Criteria andBasicAttrLessThanOrEqualTo(String value) {
            addCriterion("basic_attr <=", value, "basicAttr");
            return (Criteria) this;
        }

        public Criteria andBasicAttrLike(String value) {
            addCriterion("basic_attr like", value, "basicAttr");
            return (Criteria) this;
        }

        public Criteria andBasicAttrNotLike(String value) {
            addCriterion("basic_attr not like", value, "basicAttr");
            return (Criteria) this;
        }

        public Criteria andBasicAttrIn(List<String> values) {
            addCriterion("basic_attr in", values, "basicAttr");
            return (Criteria) this;
        }

        public Criteria andBasicAttrNotIn(List<String> values) {
            addCriterion("basic_attr not in", values, "basicAttr");
            return (Criteria) this;
        }

        public Criteria andBasicAttrBetween(String value1, String value2) {
            addCriterion("basic_attr between", value1, value2, "basicAttr");
            return (Criteria) this;
        }

        public Criteria andBasicAttrNotBetween(String value1, String value2) {
            addCriterion("basic_attr not between", value1, value2, "basicAttr");
            return (Criteria) this;
        }

        public Criteria andPresaleTypeIsNull() {
            addCriterion("presale_type is null");
            return (Criteria) this;
        }

        public Criteria andPresaleTypeIsNotNull() {
            addCriterion("presale_type is not null");
            return (Criteria) this;
        }

        public Criteria andPresaleTypeEqualTo(Integer value) {
            addCriterion("presale_type =", value, "presaleType");
            return (Criteria) this;
        }

        public Criteria andPresaleTypeNotEqualTo(Integer value) {
            addCriterion("presale_type <>", value, "presaleType");
            return (Criteria) this;
        }

        public Criteria andPresaleTypeGreaterThan(Integer value) {
            addCriterion("presale_type >", value, "presaleType");
            return (Criteria) this;
        }

        public Criteria andPresaleTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("presale_type >=", value, "presaleType");
            return (Criteria) this;
        }

        public Criteria andPresaleTypeLessThan(Integer value) {
            addCriterion("presale_type <", value, "presaleType");
            return (Criteria) this;
        }

        public Criteria andPresaleTypeLessThanOrEqualTo(Integer value) {
            addCriterion("presale_type <=", value, "presaleType");
            return (Criteria) this;
        }

        public Criteria andPresaleTypeIn(List<Integer> values) {
            addCriterion("presale_type in", values, "presaleType");
            return (Criteria) this;
        }

        public Criteria andPresaleTypeNotIn(List<Integer> values) {
            addCriterion("presale_type not in", values, "presaleType");
            return (Criteria) this;
        }

        public Criteria andPresaleTypeBetween(Integer value1, Integer value2) {
            addCriterion("presale_type between", value1, value2, "presaleType");
            return (Criteria) this;
        }

        public Criteria andPresaleTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("presale_type not between", value1, value2, "presaleType");
            return (Criteria) this;
        }

        public Criteria andSellUnitModelIsNull() {
            addCriterion("sell_unit_model is null");
            return (Criteria) this;
        }

        public Criteria andSellUnitModelIsNotNull() {
            addCriterion("sell_unit_model is not null");
            return (Criteria) this;
        }

        public Criteria andSellUnitModelEqualTo(Integer value) {
            addCriterion("sell_unit_model =", value, "sellUnitModel");
            return (Criteria) this;
        }

        public Criteria andSellUnitModelNotEqualTo(Integer value) {
            addCriterion("sell_unit_model <>", value, "sellUnitModel");
            return (Criteria) this;
        }

        public Criteria andSellUnitModelGreaterThan(Integer value) {
            addCriterion("sell_unit_model >", value, "sellUnitModel");
            return (Criteria) this;
        }

        public Criteria andSellUnitModelGreaterThanOrEqualTo(Integer value) {
            addCriterion("sell_unit_model >=", value, "sellUnitModel");
            return (Criteria) this;
        }

        public Criteria andSellUnitModelLessThan(Integer value) {
            addCriterion("sell_unit_model <", value, "sellUnitModel");
            return (Criteria) this;
        }

        public Criteria andSellUnitModelLessThanOrEqualTo(Integer value) {
            addCriterion("sell_unit_model <=", value, "sellUnitModel");
            return (Criteria) this;
        }

        public Criteria andSellUnitModelIn(List<Integer> values) {
            addCriterion("sell_unit_model in", values, "sellUnitModel");
            return (Criteria) this;
        }

        public Criteria andSellUnitModelNotIn(List<Integer> values) {
            addCriterion("sell_unit_model not in", values, "sellUnitModel");
            return (Criteria) this;
        }

        public Criteria andSellUnitModelBetween(Integer value1, Integer value2) {
            addCriterion("sell_unit_model between", value1, value2, "sellUnitModel");
            return (Criteria) this;
        }

        public Criteria andSellUnitModelNotBetween(Integer value1, Integer value2) {
            addCriterion("sell_unit_model not between", value1, value2, "sellUnitModel");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeIsNull() {
            addCriterion("count_wgt_mode is null");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeIsNotNull() {
            addCriterion("count_wgt_mode is not null");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeEqualTo(String value) {
            addCriterion("count_wgt_mode =", value, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeNotEqualTo(String value) {
            addCriterion("count_wgt_mode <>", value, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeGreaterThan(String value) {
            addCriterion("count_wgt_mode >", value, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeGreaterThanOrEqualTo(String value) {
            addCriterion("count_wgt_mode >=", value, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeLessThan(String value) {
            addCriterion("count_wgt_mode <", value, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeLessThanOrEqualTo(String value) {
            addCriterion("count_wgt_mode <=", value, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeLike(String value) {
            addCriterion("count_wgt_mode like", value, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeNotLike(String value) {
            addCriterion("count_wgt_mode not like", value, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeIn(List<String> values) {
            addCriterion("count_wgt_mode in", values, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeNotIn(List<String> values) {
            addCriterion("count_wgt_mode not in", values, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeBetween(String value1, String value2) {
            addCriterion("count_wgt_mode between", value1, value2, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andCountWgtModeNotBetween(String value1, String value2) {
            addCriterion("count_wgt_mode not between", value1, value2, "countWgtMode");
            return (Criteria) this;
        }

        public Criteria andPerformanceFlagIsNull() {
            addCriterion("performance_flag is null");
            return (Criteria) this;
        }

        public Criteria andPerformanceFlagIsNotNull() {
            addCriterion("performance_flag is not null");
            return (Criteria) this;
        }

        public Criteria andPerformanceFlagEqualTo(String value) {
            addCriterion("performance_flag =", value, "performanceFlag");
            return (Criteria) this;
        }

        public Criteria andPerformanceFlagNotEqualTo(String value) {
            addCriterion("performance_flag <>", value, "performanceFlag");
            return (Criteria) this;
        }

        public Criteria andPerformanceFlagGreaterThan(String value) {
            addCriterion("performance_flag >", value, "performanceFlag");
            return (Criteria) this;
        }

        public Criteria andPerformanceFlagGreaterThanOrEqualTo(String value) {
            addCriterion("performance_flag >=", value, "performanceFlag");
            return (Criteria) this;
        }

        public Criteria andPerformanceFlagLessThan(String value) {
            addCriterion("performance_flag <", value, "performanceFlag");
            return (Criteria) this;
        }

        public Criteria andPerformanceFlagLessThanOrEqualTo(String value) {
            addCriterion("performance_flag <=", value, "performanceFlag");
            return (Criteria) this;
        }

        public Criteria andPerformanceFlagLike(String value) {
            addCriterion("performance_flag like", value, "performanceFlag");
            return (Criteria) this;
        }

        public Criteria andPerformanceFlagNotLike(String value) {
            addCriterion("performance_flag not like", value, "performanceFlag");
            return (Criteria) this;
        }

        public Criteria andPerformanceFlagIn(List<String> values) {
            addCriterion("performance_flag in", values, "performanceFlag");
            return (Criteria) this;
        }

        public Criteria andPerformanceFlagNotIn(List<String> values) {
            addCriterion("performance_flag not in", values, "performanceFlag");
            return (Criteria) this;
        }

        public Criteria andPerformanceFlagBetween(String value1, String value2) {
            addCriterion("performance_flag between", value1, value2, "performanceFlag");
            return (Criteria) this;
        }

        public Criteria andPerformanceFlagNotBetween(String value1, String value2) {
            addCriterion("performance_flag not between", value1, value2, "performanceFlag");
            return (Criteria) this;
        }

        public Criteria andCutedgeCodeIsNull() {
            addCriterion("cutedge_code is null");
            return (Criteria) this;
        }

        public Criteria andCutedgeCodeIsNotNull() {
            addCriterion("cutedge_code is not null");
            return (Criteria) this;
        }

        public Criteria andCutedgeCodeEqualTo(String value) {
            addCriterion("cutedge_code =", value, "cutedgeCode");
            return (Criteria) this;
        }

        public Criteria andCutedgeCodeNotEqualTo(String value) {
            addCriterion("cutedge_code <>", value, "cutedgeCode");
            return (Criteria) this;
        }

        public Criteria andCutedgeCodeGreaterThan(String value) {
            addCriterion("cutedge_code >", value, "cutedgeCode");
            return (Criteria) this;
        }

        public Criteria andCutedgeCodeGreaterThanOrEqualTo(String value) {
            addCriterion("cutedge_code >=", value, "cutedgeCode");
            return (Criteria) this;
        }

        public Criteria andCutedgeCodeLessThan(String value) {
            addCriterion("cutedge_code <", value, "cutedgeCode");
            return (Criteria) this;
        }

        public Criteria andCutedgeCodeLessThanOrEqualTo(String value) {
            addCriterion("cutedge_code <=", value, "cutedgeCode");
            return (Criteria) this;
        }

        public Criteria andCutedgeCodeLike(String value) {
            addCriterion("cutedge_code like", value, "cutedgeCode");
            return (Criteria) this;
        }

        public Criteria andCutedgeCodeNotLike(String value) {
            addCriterion("cutedge_code not like", value, "cutedgeCode");
            return (Criteria) this;
        }

        public Criteria andCutedgeCodeIn(List<String> values) {
            addCriterion("cutedge_code in", values, "cutedgeCode");
            return (Criteria) this;
        }

        public Criteria andCutedgeCodeNotIn(List<String> values) {
            addCriterion("cutedge_code not in", values, "cutedgeCode");
            return (Criteria) this;
        }

        public Criteria andCutedgeCodeBetween(String value1, String value2) {
            addCriterion("cutedge_code between", value1, value2, "cutedgeCode");
            return (Criteria) this;
        }

        public Criteria andCutedgeCodeNotBetween(String value1, String value2) {
            addCriterion("cutedge_code not between", value1, value2, "cutedgeCode");
            return (Criteria) this;
        }

        public Criteria andToleranceTypeIsNull() {
            addCriterion("tolerance_type is null");
            return (Criteria) this;
        }

        public Criteria andToleranceTypeIsNotNull() {
            addCriterion("tolerance_type is not null");
            return (Criteria) this;
        }

        public Criteria andToleranceTypeEqualTo(String value) {
            addCriterion("tolerance_type =", value, "toleranceType");
            return (Criteria) this;
        }

        public Criteria andToleranceTypeNotEqualTo(String value) {
            addCriterion("tolerance_type <>", value, "toleranceType");
            return (Criteria) this;
        }

        public Criteria andToleranceTypeGreaterThan(String value) {
            addCriterion("tolerance_type >", value, "toleranceType");
            return (Criteria) this;
        }

        public Criteria andToleranceTypeGreaterThanOrEqualTo(String value) {
            addCriterion("tolerance_type >=", value, "toleranceType");
            return (Criteria) this;
        }

        public Criteria andToleranceTypeLessThan(String value) {
            addCriterion("tolerance_type <", value, "toleranceType");
            return (Criteria) this;
        }

        public Criteria andToleranceTypeLessThanOrEqualTo(String value) {
            addCriterion("tolerance_type <=", value, "toleranceType");
            return (Criteria) this;
        }

        public Criteria andToleranceTypeLike(String value) {
            addCriterion("tolerance_type like", value, "toleranceType");
            return (Criteria) this;
        }

        public Criteria andToleranceTypeNotLike(String value) {
            addCriterion("tolerance_type not like", value, "toleranceType");
            return (Criteria) this;
        }

        public Criteria andToleranceTypeIn(List<String> values) {
            addCriterion("tolerance_type in", values, "toleranceType");
            return (Criteria) this;
        }

        public Criteria andToleranceTypeNotIn(List<String> values) {
            addCriterion("tolerance_type not in", values, "toleranceType");
            return (Criteria) this;
        }

        public Criteria andToleranceTypeBetween(String value1, String value2) {
            addCriterion("tolerance_type between", value1, value2, "toleranceType");
            return (Criteria) this;
        }

        public Criteria andToleranceTypeNotBetween(String value1, String value2) {
            addCriterion("tolerance_type not between", value1, value2, "toleranceType");
            return (Criteria) this;
        }

        public Criteria andDiagonalTolCodeIsNull() {
            addCriterion("diagonal_tol_code is null");
            return (Criteria) this;
        }

        public Criteria andDiagonalTolCodeIsNotNull() {
            addCriterion("diagonal_tol_code is not null");
            return (Criteria) this;
        }

        public Criteria andDiagonalTolCodeEqualTo(String value) {
            addCriterion("diagonal_tol_code =", value, "diagonalTolCode");
            return (Criteria) this;
        }

        public Criteria andDiagonalTolCodeNotEqualTo(String value) {
            addCriterion("diagonal_tol_code <>", value, "diagonalTolCode");
            return (Criteria) this;
        }

        public Criteria andDiagonalTolCodeGreaterThan(String value) {
            addCriterion("diagonal_tol_code >", value, "diagonalTolCode");
            return (Criteria) this;
        }

        public Criteria andDiagonalTolCodeGreaterThanOrEqualTo(String value) {
            addCriterion("diagonal_tol_code >=", value, "diagonalTolCode");
            return (Criteria) this;
        }

        public Criteria andDiagonalTolCodeLessThan(String value) {
            addCriterion("diagonal_tol_code <", value, "diagonalTolCode");
            return (Criteria) this;
        }

        public Criteria andDiagonalTolCodeLessThanOrEqualTo(String value) {
            addCriterion("diagonal_tol_code <=", value, "diagonalTolCode");
            return (Criteria) this;
        }

        public Criteria andDiagonalTolCodeLike(String value) {
            addCriterion("diagonal_tol_code like", value, "diagonalTolCode");
            return (Criteria) this;
        }

        public Criteria andDiagonalTolCodeNotLike(String value) {
            addCriterion("diagonal_tol_code not like", value, "diagonalTolCode");
            return (Criteria) this;
        }

        public Criteria andDiagonalTolCodeIn(List<String> values) {
            addCriterion("diagonal_tol_code in", values, "diagonalTolCode");
            return (Criteria) this;
        }

        public Criteria andDiagonalTolCodeNotIn(List<String> values) {
            addCriterion("diagonal_tol_code not in", values, "diagonalTolCode");
            return (Criteria) this;
        }

        public Criteria andDiagonalTolCodeBetween(String value1, String value2) {
            addCriterion("diagonal_tol_code between", value1, value2, "diagonalTolCode");
            return (Criteria) this;
        }

        public Criteria andDiagonalTolCodeNotBetween(String value1, String value2) {
            addCriterion("diagonal_tol_code not between", value1, value2, "diagonalTolCode");
            return (Criteria) this;
        }

        public Criteria andUltrasonicTestLevelIsNull() {
            addCriterion("ultrasonic_test_level is null");
            return (Criteria) this;
        }

        public Criteria andUltrasonicTestLevelIsNotNull() {
            addCriterion("ultrasonic_test_level is not null");
            return (Criteria) this;
        }

        public Criteria andUltrasonicTestLevelEqualTo(String value) {
            addCriterion("ultrasonic_test_level =", value, "ultrasonicTestLevel");
            return (Criteria) this;
        }

        public Criteria andUltrasonicTestLevelNotEqualTo(String value) {
            addCriterion("ultrasonic_test_level <>", value, "ultrasonicTestLevel");
            return (Criteria) this;
        }

        public Criteria andUltrasonicTestLevelGreaterThan(String value) {
            addCriterion("ultrasonic_test_level >", value, "ultrasonicTestLevel");
            return (Criteria) this;
        }

        public Criteria andUltrasonicTestLevelGreaterThanOrEqualTo(String value) {
            addCriterion("ultrasonic_test_level >=", value, "ultrasonicTestLevel");
            return (Criteria) this;
        }

        public Criteria andUltrasonicTestLevelLessThan(String value) {
            addCriterion("ultrasonic_test_level <", value, "ultrasonicTestLevel");
            return (Criteria) this;
        }

        public Criteria andUltrasonicTestLevelLessThanOrEqualTo(String value) {
            addCriterion("ultrasonic_test_level <=", value, "ultrasonicTestLevel");
            return (Criteria) this;
        }

        public Criteria andUltrasonicTestLevelLike(String value) {
            addCriterion("ultrasonic_test_level like", value, "ultrasonicTestLevel");
            return (Criteria) this;
        }

        public Criteria andUltrasonicTestLevelNotLike(String value) {
            addCriterion("ultrasonic_test_level not like", value, "ultrasonicTestLevel");
            return (Criteria) this;
        }

        public Criteria andUltrasonicTestLevelIn(List<String> values) {
            addCriterion("ultrasonic_test_level in", values, "ultrasonicTestLevel");
            return (Criteria) this;
        }

        public Criteria andUltrasonicTestLevelNotIn(List<String> values) {
            addCriterion("ultrasonic_test_level not in", values, "ultrasonicTestLevel");
            return (Criteria) this;
        }

        public Criteria andUltrasonicTestLevelBetween(String value1, String value2) {
            addCriterion("ultrasonic_test_level between", value1, value2, "ultrasonicTestLevel");
            return (Criteria) this;
        }

        public Criteria andUltrasonicTestLevelNotBetween(String value1, String value2) {
            addCriterion("ultrasonic_test_level not between", value1, value2, "ultrasonicTestLevel");
            return (Criteria) this;
        }

        public Criteria andStandNameIsNull() {
            addCriterion("stand_name is null");
            return (Criteria) this;
        }

        public Criteria andStandNameIsNotNull() {
            addCriterion("stand_name is not null");
            return (Criteria) this;
        }

        public Criteria andStandNameEqualTo(String value) {
            addCriterion("stand_name =", value, "standName");
            return (Criteria) this;
        }

        public Criteria andStandNameNotEqualTo(String value) {
            addCriterion("stand_name <>", value, "standName");
            return (Criteria) this;
        }

        public Criteria andStandNameGreaterThan(String value) {
            addCriterion("stand_name >", value, "standName");
            return (Criteria) this;
        }

        public Criteria andStandNameGreaterThanOrEqualTo(String value) {
            addCriterion("stand_name >=", value, "standName");
            return (Criteria) this;
        }

        public Criteria andStandNameLessThan(String value) {
            addCriterion("stand_name <", value, "standName");
            return (Criteria) this;
        }

        public Criteria andStandNameLessThanOrEqualTo(String value) {
            addCriterion("stand_name <=", value, "standName");
            return (Criteria) this;
        }

        public Criteria andStandNameLike(String value) {
            addCriterion("stand_name like", value, "standName");
            return (Criteria) this;
        }

        public Criteria andStandNameNotLike(String value) {
            addCriterion("stand_name not like", value, "standName");
            return (Criteria) this;
        }

        public Criteria andStandNameIn(List<String> values) {
            addCriterion("stand_name in", values, "standName");
            return (Criteria) this;
        }

        public Criteria andStandNameNotIn(List<String> values) {
            addCriterion("stand_name not in", values, "standName");
            return (Criteria) this;
        }

        public Criteria andStandNameBetween(String value1, String value2) {
            addCriterion("stand_name between", value1, value2, "standName");
            return (Criteria) this;
        }

        public Criteria andStandNameNotBetween(String value1, String value2) {
            addCriterion("stand_name not between", value1, value2, "standName");
            return (Criteria) this;
        }

        public Criteria andMscNoIsNull() {
            addCriterion("msc_no is null");
            return (Criteria) this;
        }

        public Criteria andMscNoIsNotNull() {
            addCriterion("msc_no is not null");
            return (Criteria) this;
        }

        public Criteria andMscNoEqualTo(String value) {
            addCriterion("msc_no =", value, "mscNo");
            return (Criteria) this;
        }

        public Criteria andMscNoNotEqualTo(String value) {
            addCriterion("msc_no <>", value, "mscNo");
            return (Criteria) this;
        }

        public Criteria andMscNoGreaterThan(String value) {
            addCriterion("msc_no >", value, "mscNo");
            return (Criteria) this;
        }

        public Criteria andMscNoGreaterThanOrEqualTo(String value) {
            addCriterion("msc_no >=", value, "mscNo");
            return (Criteria) this;
        }

        public Criteria andMscNoLessThan(String value) {
            addCriterion("msc_no <", value, "mscNo");
            return (Criteria) this;
        }

        public Criteria andMscNoLessThanOrEqualTo(String value) {
            addCriterion("msc_no <=", value, "mscNo");
            return (Criteria) this;
        }

        public Criteria andMscNoLike(String value) {
            addCriterion("msc_no like", value, "mscNo");
            return (Criteria) this;
        }

        public Criteria andMscNoNotLike(String value) {
            addCriterion("msc_no not like", value, "mscNo");
            return (Criteria) this;
        }

        public Criteria andMscNoIn(List<String> values) {
            addCriterion("msc_no in", values, "mscNo");
            return (Criteria) this;
        }

        public Criteria andMscNoNotIn(List<String> values) {
            addCriterion("msc_no not in", values, "mscNo");
            return (Criteria) this;
        }

        public Criteria andMscNoBetween(String value1, String value2) {
            addCriterion("msc_no between", value1, value2, "mscNo");
            return (Criteria) this;
        }

        public Criteria andMscNoNotBetween(String value1, String value2) {
            addCriterion("msc_no not between", value1, value2, "mscNo");
            return (Criteria) this;
        }

        public Criteria andPsrNoIsNull() {
            addCriterion("psr_no is null");
            return (Criteria) this;
        }

        public Criteria andPsrNoIsNotNull() {
            addCriterion("psr_no is not null");
            return (Criteria) this;
        }

        public Criteria andPsrNoEqualTo(String value) {
            addCriterion("psr_no =", value, "psrNo");
            return (Criteria) this;
        }

        public Criteria andPsrNoNotEqualTo(String value) {
            addCriterion("psr_no <>", value, "psrNo");
            return (Criteria) this;
        }

        public Criteria andPsrNoGreaterThan(String value) {
            addCriterion("psr_no >", value, "psrNo");
            return (Criteria) this;
        }

        public Criteria andPsrNoGreaterThanOrEqualTo(String value) {
            addCriterion("psr_no >=", value, "psrNo");
            return (Criteria) this;
        }

        public Criteria andPsrNoLessThan(String value) {
            addCriterion("psr_no <", value, "psrNo");
            return (Criteria) this;
        }

        public Criteria andPsrNoLessThanOrEqualTo(String value) {
            addCriterion("psr_no <=", value, "psrNo");
            return (Criteria) this;
        }

        public Criteria andPsrNoLike(String value) {
            addCriterion("psr_no like", value, "psrNo");
            return (Criteria) this;
        }

        public Criteria andPsrNoNotLike(String value) {
            addCriterion("psr_no not like", value, "psrNo");
            return (Criteria) this;
        }

        public Criteria andPsrNoIn(List<String> values) {
            addCriterion("psr_no in", values, "psrNo");
            return (Criteria) this;
        }

        public Criteria andPsrNoNotIn(List<String> values) {
            addCriterion("psr_no not in", values, "psrNo");
            return (Criteria) this;
        }

        public Criteria andPsrNoBetween(String value1, String value2) {
            addCriterion("psr_no between", value1, value2, "psrNo");
            return (Criteria) this;
        }

        public Criteria andPsrNoNotBetween(String value1, String value2) {
            addCriterion("psr_no not between", value1, value2, "psrNo");
            return (Criteria) this;
        }

        public Criteria andCoilOuterDiaIsNull() {
            addCriterion("coil_outer_dia is null");
            return (Criteria) this;
        }

        public Criteria andCoilOuterDiaIsNotNull() {
            addCriterion("coil_outer_dia is not null");
            return (Criteria) this;
        }

        public Criteria andCoilOuterDiaEqualTo(BigDecimal value) {
            addCriterion("coil_outer_dia =", value, "coilOuterDia");
            return (Criteria) this;
        }

        public Criteria andCoilOuterDiaNotEqualTo(BigDecimal value) {
            addCriterion("coil_outer_dia <>", value, "coilOuterDia");
            return (Criteria) this;
        }

        public Criteria andCoilOuterDiaGreaterThan(BigDecimal value) {
            addCriterion("coil_outer_dia >", value, "coilOuterDia");
            return (Criteria) this;
        }

        public Criteria andCoilOuterDiaGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("coil_outer_dia >=", value, "coilOuterDia");
            return (Criteria) this;
        }

        public Criteria andCoilOuterDiaLessThan(BigDecimal value) {
            addCriterion("coil_outer_dia <", value, "coilOuterDia");
            return (Criteria) this;
        }

        public Criteria andCoilOuterDiaLessThanOrEqualTo(BigDecimal value) {
            addCriterion("coil_outer_dia <=", value, "coilOuterDia");
            return (Criteria) this;
        }

        public Criteria andCoilOuterDiaIn(List<BigDecimal> values) {
            addCriterion("coil_outer_dia in", values, "coilOuterDia");
            return (Criteria) this;
        }

        public Criteria andCoilOuterDiaNotIn(List<BigDecimal> values) {
            addCriterion("coil_outer_dia not in", values, "coilOuterDia");
            return (Criteria) this;
        }

        public Criteria andCoilOuterDiaBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("coil_outer_dia between", value1, value2, "coilOuterDia");
            return (Criteria) this;
        }

        public Criteria andCoilOuterDiaNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("coil_outer_dia not between", value1, value2, "coilOuterDia");
            return (Criteria) this;
        }

        public Criteria andCoilInnerDiaIsNull() {
            addCriterion("coil_inner_dia is null");
            return (Criteria) this;
        }

        public Criteria andCoilInnerDiaIsNotNull() {
            addCriterion("coil_inner_dia is not null");
            return (Criteria) this;
        }

        public Criteria andCoilInnerDiaEqualTo(BigDecimal value) {
            addCriterion("coil_inner_dia =", value, "coilInnerDia");
            return (Criteria) this;
        }

        public Criteria andCoilInnerDiaNotEqualTo(BigDecimal value) {
            addCriterion("coil_inner_dia <>", value, "coilInnerDia");
            return (Criteria) this;
        }

        public Criteria andCoilInnerDiaGreaterThan(BigDecimal value) {
            addCriterion("coil_inner_dia >", value, "coilInnerDia");
            return (Criteria) this;
        }

        public Criteria andCoilInnerDiaGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("coil_inner_dia >=", value, "coilInnerDia");
            return (Criteria) this;
        }

        public Criteria andCoilInnerDiaLessThan(BigDecimal value) {
            addCriterion("coil_inner_dia <", value, "coilInnerDia");
            return (Criteria) this;
        }

        public Criteria andCoilInnerDiaLessThanOrEqualTo(BigDecimal value) {
            addCriterion("coil_inner_dia <=", value, "coilInnerDia");
            return (Criteria) this;
        }

        public Criteria andCoilInnerDiaIn(List<BigDecimal> values) {
            addCriterion("coil_inner_dia in", values, "coilInnerDia");
            return (Criteria) this;
        }

        public Criteria andCoilInnerDiaNotIn(List<BigDecimal> values) {
            addCriterion("coil_inner_dia not in", values, "coilInnerDia");
            return (Criteria) this;
        }

        public Criteria andCoilInnerDiaBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("coil_inner_dia between", value1, value2, "coilInnerDia");
            return (Criteria) this;
        }

        public Criteria andCoilInnerDiaNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("coil_inner_dia not between", value1, value2, "coilInnerDia");
            return (Criteria) this;
        }

        public Criteria andWaterRateIsNull() {
            addCriterion("water_rate is null");
            return (Criteria) this;
        }

        public Criteria andWaterRateIsNotNull() {
            addCriterion("water_rate is not null");
            return (Criteria) this;
        }

        public Criteria andWaterRateEqualTo(BigDecimal value) {
            addCriterion("water_rate =", value, "waterRate");
            return (Criteria) this;
        }

        public Criteria andWaterRateNotEqualTo(BigDecimal value) {
            addCriterion("water_rate <>", value, "waterRate");
            return (Criteria) this;
        }

        public Criteria andWaterRateGreaterThan(BigDecimal value) {
            addCriterion("water_rate >", value, "waterRate");
            return (Criteria) this;
        }

        public Criteria andWaterRateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("water_rate >=", value, "waterRate");
            return (Criteria) this;
        }

        public Criteria andWaterRateLessThan(BigDecimal value) {
            addCriterion("water_rate <", value, "waterRate");
            return (Criteria) this;
        }

        public Criteria andWaterRateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("water_rate <=", value, "waterRate");
            return (Criteria) this;
        }

        public Criteria andWaterRateIn(List<BigDecimal> values) {
            addCriterion("water_rate in", values, "waterRate");
            return (Criteria) this;
        }

        public Criteria andWaterRateNotIn(List<BigDecimal> values) {
            addCriterion("water_rate not in", values, "waterRate");
            return (Criteria) this;
        }

        public Criteria andWaterRateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("water_rate between", value1, value2, "waterRate");
            return (Criteria) this;
        }

        public Criteria andWaterRateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("water_rate not between", value1, value2, "waterRate");
            return (Criteria) this;
        }

        public Criteria andOutStockIsNull() {
            addCriterion("out_stock is null");
            return (Criteria) this;
        }

        public Criteria andOutStockIsNotNull() {
            addCriterion("out_stock is not null");
            return (Criteria) this;
        }

        public Criteria andOutStockEqualTo(BigDecimal value) {
            addCriterion("out_stock =", value, "outStock");
            return (Criteria) this;
        }

        public Criteria andOutStockNotEqualTo(BigDecimal value) {
            addCriterion("out_stock <>", value, "outStock");
            return (Criteria) this;
        }

        public Criteria andOutStockGreaterThan(BigDecimal value) {
            addCriterion("out_stock >", value, "outStock");
            return (Criteria) this;
        }

        public Criteria andOutStockGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("out_stock >=", value, "outStock");
            return (Criteria) this;
        }

        public Criteria andOutStockLessThan(BigDecimal value) {
            addCriterion("out_stock <", value, "outStock");
            return (Criteria) this;
        }

        public Criteria andOutStockLessThanOrEqualTo(BigDecimal value) {
            addCriterion("out_stock <=", value, "outStock");
            return (Criteria) this;
        }

        public Criteria andOutStockIn(List<BigDecimal> values) {
            addCriterion("out_stock in", values, "outStock");
            return (Criteria) this;
        }

        public Criteria andOutStockNotIn(List<BigDecimal> values) {
            addCriterion("out_stock not in", values, "outStock");
            return (Criteria) this;
        }

        public Criteria andOutStockBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("out_stock between", value1, value2, "outStock");
            return (Criteria) this;
        }

        public Criteria andOutStockNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("out_stock not between", value1, value2, "outStock");
            return (Criteria) this;
        }

        public Criteria andStartAreaCodeIsNull() {
            addCriterion("start_area_code is null");
            return (Criteria) this;
        }

        public Criteria andStartAreaCodeIsNotNull() {
            addCriterion("start_area_code is not null");
            return (Criteria) this;
        }

        public Criteria andStartAreaCodeEqualTo(String value) {
            addCriterion("start_area_code =", value, "startAreaCode");
            return (Criteria) this;
        }

        public Criteria andStartAreaCodeNotEqualTo(String value) {
            addCriterion("start_area_code <>", value, "startAreaCode");
            return (Criteria) this;
        }

        public Criteria andStartAreaCodeGreaterThan(String value) {
            addCriterion("start_area_code >", value, "startAreaCode");
            return (Criteria) this;
        }

        public Criteria andStartAreaCodeGreaterThanOrEqualTo(String value) {
            addCriterion("start_area_code >=", value, "startAreaCode");
            return (Criteria) this;
        }

        public Criteria andStartAreaCodeLessThan(String value) {
            addCriterion("start_area_code <", value, "startAreaCode");
            return (Criteria) this;
        }

        public Criteria andStartAreaCodeLessThanOrEqualTo(String value) {
            addCriterion("start_area_code <=", value, "startAreaCode");
            return (Criteria) this;
        }

        public Criteria andStartAreaCodeLike(String value) {
            addCriterion("start_area_code like", value, "startAreaCode");
            return (Criteria) this;
        }

        public Criteria andStartAreaCodeNotLike(String value) {
            addCriterion("start_area_code not like", value, "startAreaCode");
            return (Criteria) this;
        }

        public Criteria andStartAreaCodeIn(List<String> values) {
            addCriterion("start_area_code in", values, "startAreaCode");
            return (Criteria) this;
        }

        public Criteria andStartAreaCodeNotIn(List<String> values) {
            addCriterion("start_area_code not in", values, "startAreaCode");
            return (Criteria) this;
        }

        public Criteria andStartAreaCodeBetween(String value1, String value2) {
            addCriterion("start_area_code between", value1, value2, "startAreaCode");
            return (Criteria) this;
        }

        public Criteria andStartAreaCodeNotBetween(String value1, String value2) {
            addCriterion("start_area_code not between", value1, value2, "startAreaCode");
            return (Criteria) this;
        }

        public Criteria andTransactionUnitPriceIsNull() {
            addCriterion("transaction_unit_price is null");
            return (Criteria) this;
        }

        public Criteria andTransactionUnitPriceIsNotNull() {
            addCriterion("transaction_unit_price is not null");
            return (Criteria) this;
        }

        public Criteria andTransactionUnitPriceEqualTo(BigDecimal value) {
            addCriterion("transaction_unit_price =", value, "transactionUnitPrice");
            return (Criteria) this;
        }

        public Criteria andTransactionUnitPriceNotEqualTo(BigDecimal value) {
            addCriterion("transaction_unit_price <>", value, "transactionUnitPrice");
            return (Criteria) this;
        }

        public Criteria andTransactionUnitPriceGreaterThan(BigDecimal value) {
            addCriterion("transaction_unit_price >", value, "transactionUnitPrice");
            return (Criteria) this;
        }

        public Criteria andTransactionUnitPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("transaction_unit_price >=", value, "transactionUnitPrice");
            return (Criteria) this;
        }

        public Criteria andTransactionUnitPriceLessThan(BigDecimal value) {
            addCriterion("transaction_unit_price <", value, "transactionUnitPrice");
            return (Criteria) this;
        }

        public Criteria andTransactionUnitPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("transaction_unit_price <=", value, "transactionUnitPrice");
            return (Criteria) this;
        }

        public Criteria andTransactionUnitPriceIn(List<BigDecimal> values) {
            addCriterion("transaction_unit_price in", values, "transactionUnitPrice");
            return (Criteria) this;
        }

        public Criteria andTransactionUnitPriceNotIn(List<BigDecimal> values) {
            addCriterion("transaction_unit_price not in", values, "transactionUnitPrice");
            return (Criteria) this;
        }

        public Criteria andTransactionUnitPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("transaction_unit_price between", value1, value2, "transactionUnitPrice");
            return (Criteria) this;
        }

        public Criteria andTransactionUnitPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("transaction_unit_price not between", value1, value2, "transactionUnitPrice");
            return (Criteria) this;
        }

        public Criteria andSettlementUnitPriceIsNull() {
            addCriterion("settlement_unit_price is null");
            return (Criteria) this;
        }

        public Criteria andSettlementUnitPriceIsNotNull() {
            addCriterion("settlement_unit_price is not null");
            return (Criteria) this;
        }

        public Criteria andSettlementUnitPriceEqualTo(BigDecimal value) {
            addCriterion("settlement_unit_price =", value, "settlementUnitPrice");
            return (Criteria) this;
        }

        public Criteria andSettlementUnitPriceNotEqualTo(BigDecimal value) {
            addCriterion("settlement_unit_price <>", value, "settlementUnitPrice");
            return (Criteria) this;
        }

        public Criteria andSettlementUnitPriceGreaterThan(BigDecimal value) {
            addCriterion("settlement_unit_price >", value, "settlementUnitPrice");
            return (Criteria) this;
        }

        public Criteria andSettlementUnitPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("settlement_unit_price >=", value, "settlementUnitPrice");
            return (Criteria) this;
        }

        public Criteria andSettlementUnitPriceLessThan(BigDecimal value) {
            addCriterion("settlement_unit_price <", value, "settlementUnitPrice");
            return (Criteria) this;
        }

        public Criteria andSettlementUnitPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("settlement_unit_price <=", value, "settlementUnitPrice");
            return (Criteria) this;
        }

        public Criteria andSettlementUnitPriceIn(List<BigDecimal> values) {
            addCriterion("settlement_unit_price in", values, "settlementUnitPrice");
            return (Criteria) this;
        }

        public Criteria andSettlementUnitPriceNotIn(List<BigDecimal> values) {
            addCriterion("settlement_unit_price not in", values, "settlementUnitPrice");
            return (Criteria) this;
        }

        public Criteria andSettlementUnitPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("settlement_unit_price between", value1, value2, "settlementUnitPrice");
            return (Criteria) this;
        }

        public Criteria andSettlementUnitPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("settlement_unit_price not between", value1, value2, "settlementUnitPrice");
            return (Criteria) this;
        }

        public Criteria andSendWeightIsNull() {
            addCriterion("send_weight is null");
            return (Criteria) this;
        }

        public Criteria andSendWeightIsNotNull() {
            addCriterion("send_weight is not null");
            return (Criteria) this;
        }

        public Criteria andSendWeightEqualTo(BigDecimal value) {
            addCriterion("send_weight =", value, "sendWeight");
            return (Criteria) this;
        }

        public Criteria andSendWeightNotEqualTo(BigDecimal value) {
            addCriterion("send_weight <>", value, "sendWeight");
            return (Criteria) this;
        }

        public Criteria andSendWeightGreaterThan(BigDecimal value) {
            addCriterion("send_weight >", value, "sendWeight");
            return (Criteria) this;
        }

        public Criteria andSendWeightGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("send_weight >=", value, "sendWeight");
            return (Criteria) this;
        }

        public Criteria andSendWeightLessThan(BigDecimal value) {
            addCriterion("send_weight <", value, "sendWeight");
            return (Criteria) this;
        }

        public Criteria andSendWeightLessThanOrEqualTo(BigDecimal value) {
            addCriterion("send_weight <=", value, "sendWeight");
            return (Criteria) this;
        }

        public Criteria andSendWeightIn(List<BigDecimal> values) {
            addCriterion("send_weight in", values, "sendWeight");
            return (Criteria) this;
        }

        public Criteria andSendWeightNotIn(List<BigDecimal> values) {
            addCriterion("send_weight not in", values, "sendWeight");
            return (Criteria) this;
        }

        public Criteria andSendWeightBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("send_weight between", value1, value2, "sendWeight");
            return (Criteria) this;
        }

        public Criteria andSendWeightNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("send_weight not between", value1, value2, "sendWeight");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("update_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("update_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("update_time =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("update_time <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("update_time >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("update_time >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("update_time <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("update_time <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("update_time in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("update_time not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("update_time between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("update_time not between", value1, value2, "updateTime");
            return (Criteria) this;
        }
    }

    /**
     * master_order_goods
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * @title master_order_goods表的实体类
     * @description master_order_goods
     * @version 1.0
     * @author 18304
     * @date 2021-01-20 14:35:47
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}
